Answer Questions

• Jim Griesmer [Transfer SQL Server Objects Task] Error: Table "XXXXXXX" does not exist at the source.

  Does anyone know what could be causing the error on Transfer SQL Server Objects Task   I tried to develope a SSIS project in the Business Intelligence studio to transfer table between databases on the same server.  However, I have been getting the following error: [Transfer SQL Server Objects Task] Error: Table "XXXXXX" does not exist at the source. Is there a setting that I need to change to make this work   Thank you for ...Show All

• Chitza SSIS datatypes issue.

  Dear all, I’ve made a SSIS package which take a sql statement and carry on to the .xls file but when I launch that package appears these errors: Error at Data Flow Task [Excel Destination [31]]: Column "descripcion" cannot convert between unicode and non-unicode string data types. (Microsoft.DataTransformationServices.VsIntegration) Source table have the following structure: CREATE TABLE [dbo].[SIN_Siniestro] ( [Sin ...Show All

• moondancer10 Oversized XML Docucments in SQL Server 2005

  This paper might be useful to some of you: Pushing SQL Server 2005 Limits - Dealing with Oversized XML Documents http://www.lacoude.com/docs/public/public.aspx doc=SQL90XML.pdf This paper reviews XML data handling in SQL Server 2005 and emphasizes the capability of this new version of SQL Server to manipulate extremely large XML documents. Techniques to minimize memory usage and maximize bandwidth throughput are presente ...Show All

• Maximilian Haru Raditya Connecting reporting services

  I am trying to connect "SQL Server Business Intelligence Development Studio" for reporting sevices. I am not able to figure out my connection string. i have te database and the server name. The server is not on my desktop. How do i solve this issue. Thank you Ashish I guess you are trying to figure out the connection string for a data source. If so you can use the edit button and select a few options to let B ...Show All

• recruz Importing Data from a SQL 2000 Database

  Hey there, this is probably me being very dense but i'll let you all tell me that anyway. I have a production database which is SQL Server 2000 and I have a SQL Server 2005 database which is a copy of this database taken about a month ago. I would like to set up a scheduled job to run every morning that will update the data (and only the data) in the 2005 database so it matches the production data. I've been trying to create a package using the ...Show All

• scott xxxxxxxx How to insert a record in the middle of a DB

  Well, how do you do it   I've not seen any report on this... so could it be next to impossible   Say you have 10 records, 1-10 and you want to insert a new record between record 4 and record 5 in a SQL database, just how do you code it    And oh, each record uses the auto ID increment feature. I do also need to... move.first, move.last, move.next, ect.  With the currRec to move next ...Show All

• Ying Fa Migrating Reporting services from SQL 2005 CTP (April) to SQL 2005 Enterprise

  Hi, We were trialing SQL 2005 with their CTP edition from April. The trial was a success hence we have purchased SQL 2005 Enterprise edition and would like to migrate all reports/models created in the CTP edition to the new enterprise edition. Has anyone successfully done this as there is lots of info about upgrading from SQL 2000 RS to SQL 2005 RS just none about Beta to Full version as we havent managed yet We have tried coping ...Show All

• SyedNusrat Snapshotting AS Cube

  I am currently working on a financial model that has both actual figures and budget.  Actual data is stored in the fact table where as most of the budget figures are MDX calculations.  Once a year I would like to snapshot the current year and store it.  What would the best solution be   Taking into consideration the results from MDX calculations for Budget would need to be stored in the fact when the snapshot is taken.  ...Show All

• pallavi_020 Dynamic query: EXEC - Need to get a return value from query

  I use dynamic SELECT statement trying to achive the followng: DECLARE @table varchar(50) DECLARE @ColumnA varchar(50) DECLARE @Result float SET @table = 'TABLE_A' SET @ColumnA = 'COLUMN_1' SET @SQL = ' SELECT @Result = (SUM(( ' + @ColumnA + ' )) FROM ' + @table EXEC (@SQL) I need to assign the outcome of this statement to the @Result variable. It does not work because of different contexts for @ ...Show All

• angelLee sys.objects vs. sysobjects in master..sp_ stored procs

  use master go create procedure sp_GetObjects as select * from sysobjects ; calling this procedure from different databases will return different results (behavior similar to 2000). use master go create procedure sp_GetObjects as select * from sys.objects ; calling this procedure from different databases will return results for master db only...  (ditto for all other sys. catalog views) how can I create database agnostic stored procedures u ...Show All

• Benno_GER Integers in SQL Server

  I'm having a problem with the way integers are stored internally and how they are returned with a SELECT statement.  In the project I'm working on, I have to move data from an Excel file to a database so I'm using DTS and a group of stored procs to pull this off.  What happens is: DTS pull data from Excel into temp tables Stored proc pulls from the first temp table into a supertype table IDENTITY column assigns primary ke ...Show All

• Julien T Why is Unique Constraint is prefferd over Unique Index?

  A UNIQUE constraint is preferred over a unique index. Why I agree with previous poster that there is no significant difference between Unique constraint and Unique index created on single column. both that values will be unique in column and therefore easier for optimizer to chose the index operation like SEEK and SCAN. There is one more thing with a cluster index. Clustered Index needs to be unique whether we use UNIQUE option ...Show All

• yhelfman DTS in SQL 2005 Standard

  I'm using SQL 2005 Standard Edition with the Management Studio Console CTP but I can't seem access DTS functions. Is DTS available in this edition of SQL here was my thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=349970&SiteID=1 I just got through the same issue. I upgraded from 2000 to 2005 and could no longer find DTS. It is now SSIS in 2005. I can poi ...Show All

• cwilliam SQL Server 2005 Express & Linux??

  Hi all, I'm looking at setting up my own developer server at home so I can do more programming - at work I have limited capability so want to experiment a bit more. Windows Server is far to expensive for me to consider so I'm looking at Sun Chili!Soft.ASP to run the ASP pages, etc and now just need SQL server. I have seen Microsoft now kindly offer this free version but is it likely to work on this Linux based system Sun Chili!Soft.ASP cur ...Show All

• Jonas Leine SQLServer ERRORLOG is growing everyday

  Hi, I just discovered that my production sql server(MSSQl.1\Log\ERRORLOG) is keep growing and i really don't know how to resolve this issue. I hope someone can suggest me or guide me how to resolve this issue. I searched on google but I could not find anything. This is production live sql server and I would like to delete the errorlog and can someone please tell me how.. THANKS, i RAN THE FOLLOWING STORED PROCEDURE AND IT W ...Show All