I am new to SSIS, I have experience with Informatica ETL. I am using SSIS 2008. I have setup an Oracle DB OLE Source and a SQL Server OLE DB destination. I am copying one oracle table to a table in sql server. My table has around 15000 rows. As soon as there is a single error in copying Oracle to SQL Server, my package exists. How can I ignore errors, so all the rows which do not have errors get copied? It is probably very simple to implement it, but I have not yet found how to do it.

Hi Prem, I recommend you not to ignore errors. The errors come up for a valid reason and if you ignore those, you might potentially end up with incorrect/bad data. Please check the errors and resolve them peace meal. If you need any help with errors, please post them here by opening a new tread for each specific error. Hope this helps and welcome to Integration Services forums.Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

Yes and No. This is not always a good startegy. As I said my table has 20000 rows. I want to find all the errors in one shot instead of knowing one error, then fixing it , then get another error, fixing it, etc.

In the package, there is a property called MaximumErrorCount you have to increase the value of. Again, I recommend that instead of using this, you do a partial load from the source(something like SELECT TOP 100 * FORM TableName) and deal with the errors one by one as it will faster. Hope this helps! Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

Thanks a lot, this is waht I was looking for.