Answer Questions

• rdrago Load a SSIS package via Web Service: The package failed to load due to error 0xC0011008 "Error loading from XML.WHAT IS THAT?

  Hello, I have a big problem and i'm not able to find any hint on the Network. I have a window2000 pc, VS2005,II5 and SQLServer 2005(dev edition) I created an SSIS Package (query to DB and the result is loaded into an Excel file) that works fine. I imported the dtsx file inside my "Stored Packages". I would like to load and run the package programmatically on a Remote Scenario using the web services. I created a soluti ...Show All

• WXU cannot convert between unicode and non-unicode with SQL Server

  I keep getting the error message below when attempting to import a text file (flat file) to an SQL Server Destination using SSIS. This database has recently been migrated from SQL Server 2000 (where I used a DTS Package that worked fine). I plan on doing further manipulation to the file after importing but have so far tried to keep one step at a time. I have tried using a smaller files and different tables but still get a similar response. I bel ...Show All

• Steve Landis view that unions two other views does not work

  I created a view V1 that uses an outer join with a table and calls a sub-view VS1 (ds_proj_report_date) which uses an inner join) and does an inner join with VS1. I also created another view V2 that uses inner join but does not call the sub-view VS1. When I run the two views as below it works fine Select * from V1 Union Select * from V2 I then created another view V3 of the above union as ...Show All

• VistaMadNut Why use CLR procedures for simple queries?

  Allow me to preface this by saying I'm really excited about writing stored procedures, etc. in C#!! Now...on to my question. When an application needs a simple result set (i.e., SELECT....), why use C# to write this In the samples I've seen, the developer ends up writing the select statement anyway in the CLR hosted stored procedure. What would be the benefit You end up writing more code just to write the same query. Now, executing complex logic ...Show All

• Crazy68aseric Inner Join problem

  BOL is the best. If you are absolutely new to SQL, by a book and use BOL as you read through the book. Tutorials definitely will not help much. If you don't have BOL, you can download it from here. http://www.microsoft.com/sql/downloads/2000/default.mspx And also some other SQL Server related books can be found here. http://www.microsoft.com/sql/techinfo/books.mspx /Kenneth Merit, The best way to ...Show All

• CarlMalden Full text indexing question

  All, I am using the standard edition of SQL Server 2005. I have a table I want to put a full text index on but it is greyed out. What are the reasons why it would be greyed out Thx jonp Jonp, Assuming you're using the standard edition of SQL Server 2005 RTM and that the SQL Server FullText Search (msftesql.exe) service is installed and running, there should be no reasong for the "defining full ...Show All

• SparkyDude123 Cannot design aggregations because databsae already exists

  I am clicking on "Start" in the aggregation design wizard ("Estimated storage reaches X" is selected" and I get the following error: TITLE: Aggregation Design Wizard ------------------------------ Errors in the metadata manager. The database with the name of 'CoreMarketReturn' already exists in the 'LNVDMFIISUAT01' server. To restart the process, resolve the problem, and then click Start. -------------------- ...Show All

• Andrew312 How to achieve the last Time-selection while iterating in the time-dimension itself ?

  Hello I try to explain my problem with an example: Page-filter Fields: &[Year 2003].&[Jan].&[3], &[Year 2003].&[Jan].&[4], &[Year 2003].&[Jan].&[5] (=Multiple Item Selections) Range in days = 3 days Behind the scene: [ ] [Mutation] Year 2003 Q1 Jan 1 2 3 3 (=DayRange-1+1) 5 4 2 (=DayRange-2+1) -2 ...Show All

• Sniffy Can't Edit Table

  Hello, I'm an undergrad who is using SQL Server 2005 for the first time. I have a table Components where there are three columns, ID, Name and Value, where ID and name are the composite key. I have entered some data into it from the user interface and it is entered just fine. But when I try to edit data in Value column it can't be done. This error message comes... "No Row was updated The Data in Row 7 was not committed Error source: M ...Show All

• basilgreatmouse SQL MSDE -> JDBC Connection

  Hey Guys,   I am putting a java application togehter to read from oracle into sql msde for application purposes. My problem however does not lie with the database connections per say but does regard the SQL MSDE connection string. I am getting a sucessful connection to the MSDE database instance, but it is connecting straight into the database as "master", i cannot for the life of me figure out how to connect straight into one o ...Show All

• mahmoodilyas Is it even possible to Import a flat file into SQL 2005??

  Is it possible to import a flat file in 2005   It was simple in 2000.  The DTS wizard pops-up when I dragged a file into the enterprise Manager.  Nothing like that happens in 2005.  HELP! I'm hoping someone knows of a wizard I am by no means an expert in SQL or T-SQL. Thanks is advance Does the import/export wizard not do what you want -Jamie Thanks for the reply.  Where can I ...Show All

• rumo SQL installation Error...

  i tried installing sql server 2005 express... but when i came to installing last part, the database server, it gave me this error SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}SSL Provider: The certificate chain was issued by an authority that is not trusted. help anyone Mike, Do you know how to fix this probl ...Show All

• cptscottie Turn off paging in SSRS 2005 report

  is there a way to turn paging off for an SSRS 2005 report that contains a table I assume you don't have any explicit pagebreaks in the rdl. You can set the interactive height on the report to 0 to turn off pagebreaks in HTML and preview. ...Show All

• Gareth D Adding headers to matrix

  Hi, how can I add headers to my matrixcolumns I created a table inside the merged cell above, but this won't export to excel: i get the error "Data Regions within table/matrix cells are ignored." thx, Frank Oh! And to adding matrix headers, for columns, you have to create a rectangle instead of a table. And place textbox-es inside the rectangle. And finally drag and drop the rectangle inside a merged matrix col ...Show All

• micahjj How to determine what objects (tables, indexes) reside on what filegroup in SQL2005?

  How do you check which table (schema.objectname) attached to what filegroup in SQL 2005 --example select object_name(i.id) as table_name, groupname as [filegroup] from sysfilegroups s, sysindexes i where i.id in (object_id('tablex'), object_id('tablexx')) and i.indid < 2 and i.groupid = s.groupid Hi Lito. In SQL 2005, you'll need to make use of the data_space_id column(s) in sys.indexes and sys.filegroups to get the data you w ...Show All