If I have an object of type "Microsoft.SqlServer.DTS.Runtime.Application,"
can I use one of the following functions
- ExistsOnDTSServer
- ExistsOnSQLServer
- LoadFromDTSServer
- LoadFromSQLServer
- LoadFromSQLServer2
to interact/load with a Legacy (SQL 2000) DTS package, stored on a SQL 2005 machine?
If so, can someone post an example first-argument (the Package Path) ?
Thanks.
Why would you not use the DTS object model to load and run a DTS package? Although it's a COM library, you can certainly use it from .NET...
-Doug|||You're probably right. It was worth someone verifying before assuming correctly/incorrectly.
The "Microsoft DTSPackage Object" COM object is an adequate alternative.
But this would require SQL 2000 Client Tools to be installed on the machine, in addition to SQL 2005 Client Tools, to gain use of both objects.
No comments:
Post a Comment