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.
精彩评论