DTS, Jobs, and Passwords 2

[tadd]

If the password changes for the owner of a DTS package or SQL Job, how will this affect the DTS Package or Job, if at all?

I can see how it would a DTS Package called from a command-line script, where a user name and password are provided - which is the method I use to call a DTS Pkg from a SQL Job.

 

[Catadmin]

It depends on how you're running the DTS package when you're not using the command line. If you're only running it using the command line, you'll be fine specifying it there. If you've got a job set to trigger the package, I'd look at the job and make sure it still operates.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

It shouldn't.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com