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 - 2003-02-21 : 06:39:19
|
| Christine writes "Since installing a SQL2000 instance and client tools on my server I am having problems running a DTS package on the SQL7 instance. The package runs fine when from my PC, from the command prompt on the server or using xp_cmdshell in Query Analyser. The scheduled job does nothing and returns 'The step did not generate any output' and nothing is written to the package log" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-24 : 13:30:37
|
| Have you tried rebuilding the job? If the packages executes fine from the command prompt and through QA, then the problem is with the job. |
 |
|
|
Christine Glew
Starting Member
7 Posts |
Posted - 2003-02-25 : 05:12:00
|
| Thanks for your help. I discovered that problem was that although I had installed SQL2000 on the server I had not installed any service bug and there was a bug which was resolved by SP1. Once I installed the SP then I was able to resave the package using 2000 tools (and adding an owner password) and reschedule it and it ran fine |
|
|
|
|
|
|
SQL7 DTS package does not run in SQL2000