Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2012-03-22 : 11:37:45
|
| 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. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-22 : 16:03:40
|
quote:
Originally posted by jassie
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.
keep in mind ignoring errors like above might even end up in losing useful information. so analyse first and see whats root cause for the errors and how you can handle them If not, at least log errors along with affected data somewhere for later analysis------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
ssis errors