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?
我有一个从AS400文件导入到SQL的包。程序包在Visual Studio中正常执行,但在设置为计划作业时失败。错误消息是我的密码不正确。我知道这是对的。我还设置了一个包配置,这不起作用。我搜索并尝试过很多东西。有人可以给我一些帮助吗?
5 个解决方案
#1
Have you checked Microsoft's KB article on troubleshooting such issues: http://support.microsoft.com/kb/918760
您是否检查了Microsoft的KB文章,以解决此类问题:http://support.microsoft.com/kb/918760
#2
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.
考虑您和SSIS可能引用不同密码的可能性。也许你“知道”的人实际上是正确的,但另一个则不是。
#3
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.
可能是一个愚蠢的答案,但你如何连接到AS400?如果它使用ODBC驱动程序,则需要在本地(dev)和SQL服务器框上安装AS400驱动程序。众所周知,他们对版本很挑剔。
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.
如果内存正确地为我服务,当您使用AS400驱动程序软件设置ODBC连接时,我认为您还需要指定连接详细信息并将它们显式保存在ODBC连接中。
#4
The support link above is correct. To boil it down to a simple answer. Password protect your SSIS package to save the credentials needed to connect to the AS400.
上面的支持链接是正确的。把它简化为一个简单的答案。密码保护您的SSIS包以保存连接到AS400所需的凭据。
#5
With the ODBC configuration: use a system DSN instead of user DSN, it will work!
使用ODBC配置:使用系统DSN而不是用户DSN,它将工作!
#1
Have you checked Microsoft's KB article on troubleshooting such issues: http://support.microsoft.com/kb/918760
您是否检查了Microsoft的KB文章,以解决此类问题:http://support.microsoft.com/kb/918760
#2
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.
考虑您和SSIS可能引用不同密码的可能性。也许你“知道”的人实际上是正确的,但另一个则不是。
#3
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.
可能是一个愚蠢的答案,但你如何连接到AS400?如果它使用ODBC驱动程序,则需要在本地(dev)和SQL服务器框上安装AS400驱动程序。众所周知,他们对版本很挑剔。
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.
如果内存正确地为我服务,当您使用AS400驱动程序软件设置ODBC连接时,我认为您还需要指定连接详细信息并将它们显式保存在ODBC连接中。
#4
The support link above is correct. To boil it down to a simple answer. Password protect your SSIS package to save the credentials needed to connect to the AS400.
上面的支持链接是正确的。把它简化为一个简单的答案。密码保护您的SSIS包以保存连接到AS400所需的凭据。
#5
With the ODBC configuration: use a system DSN instead of user DSN, it will work!
使用ODBC配置:使用系统DSN而不是用户DSN,它将工作!