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 |
|
jrlrwilson
Starting Member
3 Posts |
 Posted - 2002-06-21 : 15:09:52
|
| I have a dts package that when run in the designer has no errors. When running from the command line the package is executed but the last line.DTSRun: Package Execution complete never returns to the command prompt. This cause a job to periodically run the package to never complete. It needs to run every 15 minutes but cannot.Thanks, jeremyjeremy wilson |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-06-21 : 17:16:32
|
| What does the package do ? Any ActiveX Script tasks,Execute Process Tasks ? Does it need to access any external resources that might cause permission issues ? |
 |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-06-22 : 04:44:06
|
| What happens when you run it interactively from the DTS Designer itself?--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
|
|
|
DTS Run does not complete