SSIS package error

Question

Post reply

SSIS package error

gri1981

SSC Rookie

Points: 32
More actions
August 12, 2010 at 2:10 am

#227719

All,
This is with respect to some of our SSIS packages which work perfectly fine in our Development Server ( SQL server 2008) however fail with respect to some Date columns and Long columns in the production server( same version of SQL server). The data transfer when mapped without the Date and Long values happen correctly , however fail when these columns are mapped to exactly same table structures.
The transfer is happening between DB2 databases
1) The table structures are exactly identical in both the places
2) Error received is with respect to some " wrong parameters"
Appreciate any kind of help in this.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ashwani Malik Ten Centuries Points: 1140 More actions · Answer 1

Can you post an exact error, if possible the screen shot?

gri1981 SSC Rookie Points: 32 More actions · Answer 2

Hi,

Thanks for your response, the error in the log file is something like this...

OnError,CTSINTCOSPDC,CTS\peoplesoft,Package1,{2BB0E9AD-B23B-4791-B401-AAAAC807474C},{E70FB73B-6A53-45BA-B154-E8EF9A0C4000},8/12/2010 4:06:33 PM,8/12/2010 4:06:33 PM,-1073450974,0x,SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (16) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (29). 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.

the funniest part is in our development server this is working perfectly fine , whereas in Production its causing an issue for the DB2 database

steveb. SSC-Forever Points: 46733 More actions · Answer 3

it could be due to a number of things, is there another error message printed in the output which gives a more specifc error message?

Ashwani Malik Ten Centuries Points: 1140 More actions · Answer 4

According to the error your posted, there should be another error in the log before this error. Can you post that error as well?

gri1981 SSC Rookie Points: 32 More actions · Answer 5

All,

Sorry for the late response.. the issue was finally closed... the development server was a 32 bit server and production was on 64, 64 bit has compatibility issues with the IBM Db2 drivers.....

thanks!