Have Geek Brain

SSIS package does not work as a SQL Server Agent job

I have a package that is importing from an AS400 file into SQL. The package runs correctly in Visual Studio, but fails when configured as a scheduled task. the error message is an invalid password. I know this is correct. I also tweak the package config and it didn't work. I have searched and tried many things. Can anyone help me?

+1


a source to share


5 answers


You have checked out the Microsoft KB article on how to troubleshoot such issues: http://support.microsoft.com/kb/918760



+1


a source


Incorrect password.

Seriously, do you "know" your password is correct? Do you know better than the code trying to use your password? Does this seem likely to you?



Consider the possibility that you and SSIS may refer to different passwords. Perhaps the one you "know" is actually right, but the other is not.

0


a source


This might be a silly answer, but how do you connect to the AS400? If it uses ODBC drivers, you will need AS400 drivers installed on both your local (dev) and your SQL Server. They are known to be picky about versions.

If the memory is working properly when you establish an ODBC connection using the AS400 driver software, I think you need to specify the connection details as well, and they are explicitly stored in the ODBC connection.

0


a source


The support link above is correct. Bring it to a simple answer. The password protects your SSIS package to store the credentials required to connect to the AS400.

0


a source


With ODBC configuration: use system DSN instead of custom DSN, it will work!

0


a source






More articles:


All Articles