What is preferred ?

If sql I need to store the name and password somewhere - that could be a
problem - if windows I have yet to see it work the whole way around - both
in the dts package and when executing the job in Agent.

Isn't there a way to store a username and an encrypted password in a table
instead of windows logon.

Windows logins are the way forward. Even using SQL Server
authentication you would/should not need to change the username and
password surely.

The reason why most times a DTS job fails is this

http://support.microsoft.com/?kbid=269074

"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote