From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Handling errors in an SSIS package

Handling errors in an SSIS package - SQL Server Tutorial

From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012

Start my 1-month free trial

Handling errors in an SSIS package

“

I'd like to talk about handling errors in an SSIS package. We occasionally get errors from time to time in our data inputs. It could be something like a required field being missing, or the wrong type of data coming over. When we expect a number, we get a string or vice versa. When these things happen, we typically don't want the entire package to fail. We would like all of the good rows to still be processed as normal and then do something to notify us about the bad rows. SSIS makes it easy to redirect those bad rows to another data destination. And we can come back and analyze them in the future. I'm going to create a new SSIS project, default name, default location. In the Control Flow, I'll just need one data flow task. I'll double-click on that. First thing I'm going to need is a source. So I'll double-click on Source Assistant. I'd like a flat file and it'll be a new connection. The file I want to import data from will be ResellerSalesErr, in other words, with errors. If we look…

Contents