开发者

Executing a DTS package from Sql Server 2005

I am trying to run several DTS packages from a sql 2000 box. The DTS calls will originate from .net 2.0 - 3.5 code. I have been unable to find a good way to programmatically accomplish this. What I have read is running a sql job from a stored procedure that calls the DTS package. Does anyone has any experience with this or know of a good way to call the DTS?

Note: For the forseeable future these packages will remain DTS. Eventually we will convert them to SSIS.

Any insight or experienc开发者_高级运维e would be very helpful.


I was in a similar situation at work, and we ended up 'wrapping' our DTS packages with single-step SSIS packages that use DTSRun (installed with Sql 2005) in a command-line fashion to call to invoke a DTS package on the file system. If you were to do that, then it'd be a matter of programmatically launching an SSIS package which I'm not familiar with but it's got to be just as possible as DTS on 2000.


Ahhh.. I have found a Com Object in the .net library that allows me to interact. Its is Microsoft DTSPackage Object Library. Problem averted.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜