APIs for executing DTS package

[anirudhadeo]

Hi,
I have few question regarding DTS packages.

Can we execute DTS packages through APIs.Do we have Any APIs for it?
Can we transfer the DTS packages from MAchine to machine and if yes what is the file format for a DTS package?

Hope these questions make sense ....
waiting for your reply
Thanx for your interest
Regards Anirudha

 

[tlbroadbent]

There is an API - "Microsoft DTSPackage Object Library." Check out the great info about executing DTS packages available at SQLDTS.com.

http://www.sqldts.com/catlist.asp?nav=1,6,104,5

The SQLDTS site also contains info about transferring pacakages between servers.

http://www.sqldts.com/main.asp?nav=1,6,204,0

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.