hello i am getting these errors while using SSIS package for migrating oracle to SQL. 1)[OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "ORA-01555: snapshot too old: rollback segment number 1 with name "RBS0" too small ". 2)[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC0202009. 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. I am using OLEDB SOURCE and OLEDB DESTINATION. ALSO i am using data conversion TRANSFORMATION THANKS IN ADVANCE dimrd_SQL

This is Oracle Problem Please look at following http://forums.oracle.com/forums/thread.jspa?threadID=345689 I think you should contact you ORACLE DBA for that, he will be able to guide you. Gaurav Gupta http://sqlservermsbiblog.blogspot.com/