Quick answer....  
Author Message
iparadox





PostPosted: Wed Nov 12 18:15:21 CST 2003 Top

SQL Server Developer >> Quick answer....

How do I execute a DTS package using a stored procedure (without using
xp_cmdshell to use dtsrun utility)

Thanks

SQL Server99  
 
 
EB





PostPosted: Wed Nov 12 18:15:21 CST 2003 Top

SQL Server Developer >> Quick answer.... From Transact-SQL, I can't find a way. I must honestly say, I expected it to
be possible.
Answer is, among other sources, based on
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_pkgmng_6asl.asp.

Regards,
EB


 
 
Sue





PostPosted: Wed Nov 12 18:30:36 CST 2003 Top

SQL Server Developer >> Quick answer.... Use OLE Automation stored procedures (i.e. sp_OAxxx) and the
DTS objects. Sample at:
http://www.databasejournal.com/features/mssql/article.php/1459181

-Sue

On Wed, 12 Nov 2003 15:33:10 -0800, "I_AM_DON_AND_YOU?"


>How do I execute a DTS package using a stored procedure (without using
>xp_cmdshell to use dtsrun utility)
>
>Thanks
>