Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
micheal
Starting Member
2 Posts |
 Posted - 2004-08-23 : 08:00:31
|
| Hello,I'm fairly new to SQL Server and have just run into a problem while trying to execute a DTS package from a stored procedure. Initially the package executed but I got an error (this was because of a problem with the table the data was being copied to). However, I have now sorted this problem and although the stored pro works and does not throw any errors the package does not run. I have manually executed the package and it works fine - it just won't work from the stored pro. Is there something I need to delete somewhere because it errored to get it to run properly?? I'm completely stumped.Thanks in advanceMicheal |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-08-23 : 08:23:42
|
| How are you running it ?If you've got an encoded parameter, make sure you're running the right version.-------Moo. :) |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-23 : 08:51:56
|
| Whoever is executing the procedure needs permissions to run the DTS package as well.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Problem executing DTS from stored procedure