April 10, 2006 at 1:25 pm
Hi,
We have our source data in AS400 and we use [IBM][iSeries Access ODBC Driver] to connect to the data source.
Our problem is the ODBC Connection manager (ODBC Data provider) in SSIS doesn't seem to pick up the password from the Configuration file.Due to this we get the following error at run time,
[DataReader Source [1]] Error: System.Data.Odbc.OdbcException: ERROR [28000] [IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=8002 - CWBSY0002 - Password for user REPORTS on server RBGDC0P5 is not correct, Password length = 0, Prompt Mode = Never, System IP Address = 212.189.19.21 ERROR [28000] [IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=8002 - CWBSY0002 - Password for user REPORTS on server RBGDC0P5 is not correct, Password length = 0, Prompt Mode = Never, System IP Address = 212.189.19.21.
However same works well with OLE DB connections. Appreciate any help/suggestion in this regard.
Thanks
Srividya
April 11, 2006 at 7:34 am
We have had similar problems. We ended up using the ".NET Providers\ODBC Data Provider" type of connection. Then in the Data Flow task, we use a DataReader source to get the iSeries data. Also, make sure that you "re-enter" the password in the configuration file. It appears that the password value is not exported upon the initial creation of the configuration file.
Dan
July 20, 2006 at 4:03 pm
I have the same problem. After playing with it several times, I think the problem is the connection string stored in the configuration file. The connection string value generated by the Configuration is not working. However, if I copied the connection string generated at the connection manager for AS400, it works.
February 16, 2009 at 12:51 pm
has anyone been able to use a script component to connect to a AS400 system? I have the datareader working on previous SQL 2005 box but we are moving to another sql 2005 box that is supposely a direct duplicate of the previous machine. However, I cannot seemt to get the AS400 packages working in SSIS anymore. I test a DTS package and I was able to connect and retrieve data but I cannot from SSIS on this new machine.
I cannot find anything different on this machine than the previous machine. Any suggestions?
[DataReader Source [1]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "DataReader Source" (1)" failed because error code 0x80004003 occurred, and the error row disposition on "output column "column_name" (22)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
February 16, 2009 at 12:52 pm
I just found out that the previous server have 2.0 and 3.0 .NET Framework components installed. I am checking to see if the second server has them installed as well. Would not having 3.0 components installed cause a problem with the datareader task not being able to connect to the AS400 system?
January 11, 2011 at 12:38 pm
You might check to see if IBM i Access is installed on the server (or wherever the package actually runs). Minimally, you'll need the DB provider installed.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply