DTS provides an object library that can be called. To do this, your package can be saved either to SQL Server or as a Structured Storage file. See the SQL Server BOL for more details on how to do this.
This question has also been answered in thread961-505892.
royyan,
Please avoid cross-posting to multiple forums. Read the FAQS in my signature below to find out why? If you want to get the best answer for your question read faq183-874 and faq183-3179. Terry L. Broadbent - DBA
SQL Server Page:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.