Ok, that looks useful. This may be a dumb question, but how do you determine the encrypted password?

I see in the DTSrun utility, you can create a...

Hey, that's it!!! I recreated the JOB and the new job runs with the password change. The problem was in the DTSRun command. The original had...

Unfortunately, no scheduled jobs will run at all if the owner is a domain account. I suppose that it is because we are running NDS instead of a Windows...

SA owns the job all 3 cases. I had also tried changing the owner of the job that runs DTS1 to another SQL Login and got the same error...

This is really driving me nuts! Here is an example:

DTS1 originally had a connection object to the SQL Server using SA. The connection was changed to "Windows Authentication"....

This will help you find out what the error is instead of "The job failed...". Go to the properties of the scheduled job. Go to the Steps tab...

Yeah, I've had to deal with incorrectly restored databases before. There is a cool stored proc called sp_help_revdatabase that will create the script. Thanks for your advice on...

I think what you are saying is that I should upgrade to SQL 2000 first before going to Win2k. I doubt that my managers would go for that, but...

Look at "Copying DTS Packages To a Different Server" by Andy Warren in this site. I recently moved some DTS packages from a SQL 7 box to a SQL 2000...

The method described in http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp worked!

Kathi

quote:

---

I just found an article here written by Andy Warren about automating the transfer of DTS packages . I am doing...

I just found an article here written by Andy Warren about automating the transfer of DTS packages . I am doing some testing on password protected packages. I'll...