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
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL7 DTS package does not run in SQL2000
- Thread starter glewc
- Start date
- Thread starter
- #2
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
- Status
Similar threads
- Locked
- Question