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...

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"...