Set up a DTS to transfer data from an AS/400 to SQL Server
7 using a file DSN (Client Access ODBC Driver (32 bit)).
It works great except that every time I run it, it asks me
to log into the AS/400, even though I specified the ID and
password in the DSN and DTS.
Also, tried to set the password for the DTS connection using Disconnected Edit to no avail. The password always blanks out. Seems something is blocking the saving of the password.
I need to run this unattended, daily without a manual log