Running SQL Server Local Package from Stored Procedure

[sjuarez1979]

Can a SQL server local package be run from a stored procedure? If this is possible, what would the syntax look like?
Thanks a bunch!

-sjuarez1979

 

[tlbroadbent]

See the article at SQLDTS.com regarding execution of DTS Packages from T-SQL. The article contains additional links to code samples.

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

You can find more DTS links in faq183-962. 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 in the SQL Server forum. Many of the ideas apply to all forums.

 

[sjuarez1979]

What is the difference between Meta Data Services Package and Local Package anyways while we are on the subject?

 

[tlbroadbent]

Meta data Services packages are DTS packages stored in the Repository. Local Packages are stored in MSDB on the SQL Server. 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 in the SQL Server forum. Many of the ideas apply to all forums.