Does anybody know what the recommend method is to copy data from one table to another using a DTS? Should we use the standard Insert/Select statement or a DTS transformation between two connections? Which one is faster? Has anybody done every any performance test on this? I am using SQL Server 2000 right now, but would also like to know...
Hello ! I have an excel file (xlsx) containing a table : Once I launched my ssis task (successfully) to insert data in it, it is actually append after the table : My expected result: So I am looking for a way to insert into the table and expand it with the data. I hope someone could help me. Thank you ! ...
We have a number of import jobs that previously worked fine. These dtx packages were execute from VS2005 on a Windows XP box with Office 2007 installed. The developer has not got a nice new machine, 64bit, Windows 7, Office 2010. Now when he tries to execute the packages he gets the following error: SSIS package "Import_BygningsKa...
Hi, I am executing a SQL Server 2000 DTS package using C# by following the code from this article http://support.microsoft.com/kb/319985. once the package is executed I am looping through each step to find out if any step has failed and get info about error if it has failed. I also use this information to find out if the package has succ...
Hi Team, I am doing an SSIS package that would go out to all our DB servers to gather information about them, and what is on them. And in this one case there is a SQL 2000 box with a bunch of DTS packages on there. Now I can easily list the Local Packages using "exec sp_enum_dtspackages", but this doesn't list the Meta Data Services P...
I have a Data Flow task with an XMLSource that references an XML Variable. The DataFlow task does recognize that there are x number of rows in the variable, but it only sees null values in every row: The xml variable value: <?xml version="1.0" encoding="utf-8"?> <words> <word>butter</word> <word>crispy</word> </words> I used th...
Hi, I am deploying some integration services into a SQL Server 2005. On my computer, I don't have any validation error but I do on the server. It comes from an OLE DB connection manager: "Login failed for user 'rw_user'". Whereas I can fully run it on a client, the connection works perfectly. This is a connection to the server itself....