dbTalk Databases Forums  

DTS execution from stored procedure

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS execution from stored procedure in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
corben
 
Posts: n/a

Default DTS execution from stored procedure - 04-22-2004 , 03:46 PM






Hi everybody

I need a little help. I'm usually use stored procedures to launche DTS packages automatically using OLE automation functions and it was working just fine until this

I've got a package turning the content of one table into an excel file and I want to launch ths package as usual using OLE automation procedures. But in this case, the package is not running and the process shows a failure status. when I'm using the package manually it's working fine

Does someone's got the case previously ? and how can I get througt this ? package rights, login and all this stuff is exactly the same as usual but no way to have it working on launch by a SP

Thanks for your help..


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.