February 18, 2009 at 3:31 am
Dear ALL,
I am stuck into a weird problem.
Actually i am trying to insert data in DB2 OS/390 7.1.1 through OLE DB Destination in SSIS.
The provider i am using, while creating connection manager is "IBM OLE DB Provider for DB2" from drop down list.
But when i try to insert data from a source any (no matter oracle or SQL server) it gives me the error
[OLE DB Destination [55]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E53.
[DTS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination 1" (834) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Connection is poperly establish, once can test connection and it gives Sucess.
User have proper rights, you can select the same data when u create DB2 as a OLE DB source. And another strange thing one you insert data through a Execute sql Task and give insert statment .....it inserts the data..................but the same data with OLE DB Destination, gives me the error mentioned above.
we have 2 millions rows to inserts in DB2, ervey now n then.....so can any body suggest me how could i fix this problem...........dont wanna use script component.....in that case i might have to insert row by row....which is really a performance hit.
IS this a known issue........any fix....way around.
Your quick response is highly appreciated.
Thanks
Report post as abusive
May 16, 2012 at 12:22 am
Hi,
Did you get any response this one? Was this issue resolved? I am facing the exact same issue. Please let me know if you have any work around or solution to this.
Appreciate your help.
Thanks.
May 17, 2012 at 6:27 am
Have you tried using OPENQUERY ?
May 20, 2012 at 9:21 pm
Hi,
I am new to SSIS package. Can you please provide details on OPENQUERY and how to do it? If that resolves the issue, then nothing like that...it will be a great help.
Thanks,
Kunal
May 20, 2012 at 9:29 pm
I see that OPENQUERY is used along with Linked Server. I cannot create Linked Server. Hence, I need to create either SSIS pacakbe or code it.
Do you have any other pointers on how to transfer data from SQL Server to DB2?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply