December 16, 2008 at 12:33 am
Hi All,
I’ve designed a SSIS package (SQL 2005) for reading data from Excel Source & WRITE into a DB2 Mainframe database. While EXEC the package, I’m getting the following error:
Error:
[DTS.Pipeline] Error: The ProcessInput method on component "OLE DB Destination" (81) 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.
Also attached the screen shot of Error message for more details.
If anyone has designed package for DB2 earlier, please can you help me to resolve the problem.
Cheers,
Suresh
Suresh
December 16, 2008 at 7:26 am
What oledb provider are you using?
Have you checked the OLEDB providfer documentation for that error?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 16, 2008 at 11:24 pm
Hey Jack,
Thanks for your response.
The problem has been resolved now. It's due to lower version of DB2 provider. I got DB2 ver 9.1 provider installed & it's working fine 🙂
Suresh
December 17, 2008 at 6:58 am
Thanks for posting your fix. Many people don't do that.
I've had the same problem with the .NET provider to DB2 as well. IBM seems to break things every time they do an update.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply