If you select a group of tasks, then copy and paste, the order of the shapes is completely mixed up. Why can't it remember the layout of the tasks? Visio can....more >>

The following is received when trying to edit a data flow task which has been copy and pasted. WHY!? TITLE: Editing Component ------------------------------ The component has detected potential metadata corruption during validation. Error at Update Counterparty Table with new counterpartie...more >>

When SSIS is not erroring with "SerializeComponentFailed" when trying to copy and paste, it only half works. e.g. select 2 ole sources going into a merge join and a few tasks after this and it does not bother to pull across half the tasks on pasting Why can't the managers from the SSIS tea...more >>

I am getting the following errors when performing a simple import data wizard using excel as source: - Validating (Error) Messages Error 0xc0047008: Data Flow Task: The package contains two objects with the duplicate name of "output column "ErrorColumn" (12)" and "output column "ErrorColu...more >>

Hi, it seems that I cannot externalise the Fuzzy Lookup properties (the one which set the number of records to fetch and the other one to set the similarity threshold). Has anyone try to externalise them? Is there a workaround? thx, Chris ...more >>

hi, i just exported data from the Excel to the Text file using DTS package. then i want to add Header field and as well as Footer field to to the text using DTS package. if i use the option first column as header here i use different column name so i what change that data .. what i can do ...more >>

Hi, I am unable to put a Precedence Constraint within a For Loop Container, can I do so in SSIS ? Actually what I am trying to acheive is that I am Iterating the ForLoop on some File List which will pull one FileName out of the List at a go n pass on the file name to the FTP Task so that...more >>

I have a DTS package that picks up a file from a folder than loads to a staging table. Then some cleanup is done by an SP before finally loading the live table from staging. Now I have a second file that needs to run thru the same process but there maybe times when it's empty. 1) I don't w...more >>

I am seeing some strange behavior - I am trying to load data from 2 tables, one having approx 94,000 rows and the 2nd having approx 1.4 million rows. The two transformation tasks in my dts package load only about 800 & 200 rows respectively from these tables, and succeed. How is this possibl...more >>

I need at least Visual Studio 2005 Professional in order to install and use SSIS right, because you can only access SSIS via Business Intelligence For Visual Studio...is that correct? I have Visual Studio Standard, and it seems that won't do. Can anyone confirm? Thank you. ...more >>

The SSIS designer is unstable. It keeps dropping out on me without even showing the 'send error to ms'. The latest problem which *did* show an error is shown below (was caused by using that rare function known as 'copy') The help link does not work and if you google on SerializeComponents...more >>

Hi , I had import the DTS Sql 2000 to Sql 2005. When I run the package and test the result , surprisingly the performance is very slow compare to Sql 2000. What is wrong in there ? The new server on Sql 2005 had 4 CPU , 8 GB memory and running on windows 2003 enterprise. Already e...more >>

I am working on a development project where we have an office in Canada and another one in India. The coders all work in India, and because of the pipe there, their internet access is unbearable, making a network connection to my master DB here impossible... the manager here asked for a copy to...more >>

Hi to all, I have tried to pass the parameters using Active x script in DTS..... by using DTSlookup query..... But icant able to create the object for DTS lookup and cant able to execute.... I have copied the code below: '***********************************************************...more >>

Hi, I have to pass the input parameters using Active Xscript in DTS... I have tried using DTS lookup queries..... after getting the queries and i can't able to create the object for DTSlookup..... How could i create and execute the DTS lookup query... i have copied my code below ......more >>

I made several hours worth of changes to a DTS Package, and am unable to save the changes. I get the following message: Package Error Error Source: Microsoft Data Transformation Services (DTS) Package Error Description: Code execution exception: EXCEPTION_ACCESS_VIOLATION The above is all...more >>

Just wanted to pass on some information regarding SSIS that can save you some pain down the road...the Fuzzy Lookup feature of Integration Services is not supported on the Standard Edition of SQL2005. What makes this sort of a "gotcha" is that you can open BIDS (Visual Studio) on a machine wit...more >>

I tried to specify *.xls, *.csv in the Files text box. but it doesn't work....more >>

I have used the DTS legacy features of SQL Server 2005 to import DTS jobs from SQL Server 2000 to 2005. I can edit and execute the jobs in SQL Server 2005. However, there does not appear to be a method to schedule the execution of the job in SQl Server 2005. This was a menu choice in 2000, ...more >>

I am importing a text file to a table with a smalldatetime field. the format of the text file date is DDMMMYYYY(05OCT2006). It says that it is an invalid data type for this field on my SQL table. When I run query analyzer and use an isdate function it tells me it is a valid date. I am trying ...more >>

Hi guys, I have an Execute SQL Task which does an UPDATE, but basically, has this DECLARE @source_file_id as INT SET @source_file_id = ? DELETE FROM test WHERE test_id IN (SELECT FT.test_id FROM test AS FT JOIN raw AS FR ON FR.source_id = FT.source_id AND FR.original_number...more >>

Hi.. I want to update table using SSIS. I figured that there are two ways of it: 1. Use SQL command (but I cant use it as I have millions of rows) 2. Put updated rows in temp table and perform the batch update using Execute SQL task. (If possible, I dont want to use temp table) Source and ...more >>

Hello! I have a few DTS packages that I save on disk. I have been editing quite a lot and they seem to grow in disk size. I guess it is because of the versioning capabilities. I would like to drop some versions and reduce the size of the packages. How can I do that? regards Clarkie ...more >>

Hi, I have tried to pass the parameters in DTS by using the following snippets by using ActiveXscripts; but it wont work...... Dim strPackage, strSQL Dim oFSO Dim sSourceFile Dim sDestinationFile Set oFSO = CreateObject("Scripting.FileSystemObject") 'strPackage=InputBox ("...more >>

I have a table in SQL Server 2000 that contains filenames in a text field and files of various types (.doc,.xls, .jpg) in a image datatype field. I would like to write a program within a dts package that would read each and write the contents of the image field to a directory, saving it with the...more >>