I have a package that imports from a AS400 file to SQL. The package executes properly within Visual Studio, but fails when set up as a scheduled job. the error message is that my password is incorrect. I know that it is correct. I also setup a package configuration and this did not work. I have searched and tried many things. Could someone give me some assistance?
A:
Your password is incorrect.
Seriously, you "know" that your password is correct? You know better than the code attempting to use your password? Does this seem likely to you?
Consider the possibility that you and SSIS may be referring to different passwords. Maybe the one you "know" is correct actually is, but the other one is not.
John Saunders
2009-05-26 17:13:19
Well i know that it successfully connect to the source in the DB connections within the package using visual studio. And the package runs succefully within VS. If the password was not correct, this process wouldn't work, right? if i look at the command line tab in the first step, the password is not in the string. should it be? i see all the other connection information but not this. I tried adding it with no success.
2009-05-26 17:26:37
A:
Possibly a stupid answer, but how are you connecting to the AS400? If it's using ODBC drivers, you'll need the AS400 drivers installed on both local (dev) and your SQL server box. They're notoriously picky about versions.
If memory serves me correctly, when you set up the ODBC connection using the AS400 driver software, I think you need to specify connection details as well and they get explicitly saved in the ODBC connection.
Dane
2009-05-27 01:50:54
+1
A:
Have you checked Microsoft's KB article on troubleshooting such issues: http://support.microsoft.com/kb/918760
Michael
2009-05-27 08:33:39
A:
With the ODBC configuration: use a system DSN instead of user DSN, it will work!
LIA
2010-03-01 13:51:18