Hi

I have successfuly created a DTS package to Read Data from
an AS400 database, using an OLE DB connection (Driver).

On the OLE DB Properties, there are 2 options, 1) Blank
Password, and 2) Allow Password saving.

However, I try to set the password, and it still always
prompts me, in other words, either the OLE DB or the DTS
package will not save the AS400 DB Password. Hence when I
try to schedule the package, it fails, since the DB
password is incorrect.

I also generated the SQL Script from the job scheduler,
however, there is no option to SET DB Pword in the DTS_Run.

Any ideas on how to get around this?
Many thanks
Traci