I a开发者_Python百科m looking online and would like to migrate my DTS Packages to SSIS using migration wizard, but when I go to convert packages it says I must Install DTS Runtime, when I look online,
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:
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 fin
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.
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 t
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.
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
I\'m sure that this is a pretty vague question that is difficult to answer but I would be grateful for any general thoughts on the subject.
I have a DTS package, which after running daily with no problems for a couple of years, has started to play up. Originally it was inserting data into a table which would then fire an insert trigger. T
Is开发者_StackOverflow there a way to stop a SQL Server 2000 DTS (not SSIS) package that is currently running, programmatically using C#?. I think the package can be executed using the COM API, but I