February 27, 2015 at 3:01 pm
Hi all..
Now I have created my SSIS packages that takes data from SQLserver to AS400 , I use OLEDB connection for both SOURCE and TARGET
I deployed the SSIS pkg in Dev SQLServer with all connection string username /password etc., but when execute pkg is not able to connect to the AS400
I'm getting the following error
DEVDATAPackage:Error: The requested OLE DB provider DB2OLEDB.1 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
there is little or no help available on this topic/error in the internet.. hope someone will help me here..
My setting is almosst like this
and i also tried some solutions mentioned here too
none of them helps... :(:angry:
Thank you
February 28, 2015 at 4:59 am
Quick thought, check that the DB2 ODBC drivers are installed on the server running the SSIS and that they match the architecture of the SSIS package execution.
😎
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply