Execute Package from Stored Proc

Question

Post reply

Execute Package from Stored Proc

Richard Buchner, Chicago

Ten Centuries

Points: 1390
More actions
October 21, 2002 at 9:32 am

#105696

Hi all,
Can you execute a local package from a stored procedure.
Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

Yes, but if you're staying pure T-SQL, you'll have to use xp_cmdshell and execute the package using DTSRun.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

K. Brian Kelley
@kbriankelley

Richard Buchner, Chicago Ten Centuries Points: 1390 More actions · Answer 2

Thanks, Brian,

What do you mean by pure Tranact SQL?. What I really would like to do is execure the package from a Access project. tought I could do so by setting up an Sproc, to be invoiked by the Access project, is theire a better way?

Thanks

vstitte SSCarpal Tunnel Points: 4475 More actions · Answer 3

You can use the DTSPackage Library. The DTS Package Library exposes objects that can be invoked using VB code in Access to execute the DTS packages. Refer to SQL Books Online and look under DTS Programming for detailed info and syntax.