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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-13 : 07:26:06
|
| Kyaw writes "There is a DTS package that work when when it is executed directly from Enterprise Manager and dtsrun utility.But it does not work when it is executed from a stored procedure.Do you have any idea?" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-09-13 : 09:46:55
|
| "does not work"....does it fail to start, or does it start and not achieve any work?Can you trace/log how far into the package it goes?Access rights would seem to be the direction to investigate further. |
 |
|
|
|
|
|
Executing DTS package