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.. |