HELLO i AM DOING ORACLE TO SQL MIGRATION using OLEDB SOURCE AND OLEDB DESTINATION. USING DATA CONVERSION TRANSFORM. Q:1) HOW SHOULD I MAP NUMERIC DATATYPE? Q:2) HOW TO RESOLVE THESE ERRORS: [OLE DB Source [175]] Error: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (175) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. THANKS IN ADVANCE dimrd_SQL

I use Data Conversion component in DFT just after OLEDB Source and convert it into eight byte signed integer. that works for me.Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

I had a lot of problems with Money and Dates going from Oracle to SQLServer. I usually try to export Oracle to a flat file then import that flat file. If your using a linked server the openquery will work you just have to keep trying different combinations. So I'd try exporting to a flat file.