dts
SQL Server: does SQL Server 2008 64 bit support DTS Runtime?
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,[详细]
2023-01-24 04:47 分类:问答SSIS XMLSource only seeing null values in XML variable
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:[详细]
2023-01-21 22:14 分类:问答Error handling in DTS Package execution using .NET
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[详细]
2023-01-21 16:27 分类:问答SQL Server 2005 - SSIS validation error server-side only
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.[详细]
2023-01-21 08:53 分类:问答SQL Server 2000 Script to list all Meta Data Services DTS packages
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[详细]
2023-01-20 17:16 分类:问答SSIS packages to import Excel Files into SQL Server
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.[详细]
2023-01-19 11:56 分类:问答DTS Transformation vs Select/Insert into t
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[详细]
2023-01-18 23:45 分类:问答DTS/SSIS vs. Informatica Power Center
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.[详细]
2023-01-16 07:19 分类:问答Performance of update statement inside DTS package
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[详细]
2023-01-15 03:50 分类:问答stop a DTS package programmatically (using C#)
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[详细]
2023-01-11 06:03 分类:问答