From the course: SQL Server Integration Services
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Error handling in data flows - SQL Server Tutorial
From the course: SQL Server Integration Services
Error handling in data flows
through the failure precedence constraint. Errors in data flows can be handled in a similar way, to an external file for review, in order to determine what the issue was that caused the failure. To see how this could work, I've got a data flow task setup that's going to attempt to copy data out of the Wide World Importers data warehouse, and write it into the Kineteco database. If I open up the source connector, you'll see how it's configured. We currently have a connection to the Wide World Importers data warehouse here, and we're using a SQL command to select the distinct suppliers from Dimension.Supplier. I'll press the preview button. You'll see what that data looks like. So this is what we're pulling out of the data warehouse. I'm going to close this and say okay, and then take a look at the destination. The destination hasn't yet been configured, so I'm going to use the OLE DB connection manager. And, let's see, it's not in the dropdown menu, so I'm going to press cancel here…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.