March 22, 2012 at 9:40 am
Is ignoring errors in an SSIS package ok? If I chose to ignore the errors in a production load, are there some problems I should be aware of?
I want to seup an SSIS package in sql server 2008 r2 taking data from a specific tab in an excel workbook 2003 and write out the data to sql server. When I use the import wizard, I tell the wizard to ignore all errors that occur. The data gets loaded the way I want it to. If I tell the wizard to fail on errors, it stops and the data does not get loaded.
March 22, 2012 at 11:34 am
wendy elizabeth (3/22/2012)
Is ignoring errors in an SSIS package ok? If I chose to ignore the errors in a production load, are there some problems I should be aware of?I want to seup an SSIS package in sql server 2008 r2 taking data from a specific tab in an excel workbook 2003 and write out the data to sql server. When I use the import wizard, I tell the wizard to ignore all errors that occur. The data gets loaded the way I want it to. If I tell the wizard to fail on errors, it stops and the data does not get loaded.
Ignore failure is not suitable for all the errors...
In my experience, if one of your column has null values and which is not supposed to be inserted into not null destination column, ignore failure option will not work for this case....
so take a look at what the error was ..and come back, we will our best to solve it..
Thanks,
Charmer
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply