Join Ron Davis for an in-depth discussion in this video Handling errors, part of SQL Server Integration Services (2015).
- Ok, let's look at handling errors,…and the errors we're concerned about here…is not the errors in the Control Flow.…If you remember in a Control Flow,…the way we handle the errors is we do that…with Precedent Constraints.…So we come over and we connect…one task over into the other,…and then we simply have one task…that on Failure,…so we have down here on red.…So we would have multiple tasks.…So one task down here with the error,…and the other one always be on success.…And handling errors in the Control Flow is easier.…
Let's just delete that out.…What we're interested in here…is the more difficult handling errors in the Data Flow.…I've got three Data Flows set up.…The first one is just a little read from Excel…and send it into the database.…So I'm gonna go through and Execute that…just to show a working task.…Goes down, dumps it into the database…and we Shift F5 to break out.…
And now we've got that,…and we can come in, let's look at our Data.…And we can View Existing, and we see…the Data was actually inputed.…We'll close…
- Creating SSIS packages
- Coding and looping tasks
- Managing and administering SQL with SSIS tasks
- Optimizing data for extraction
- Making packages dynamic with variables and parameters
- Using sequences in a container
- Performing joins
- Handling errors
- Working with XML
Skill Level Intermediate
Querying Microsoft SQL Server 2012with Gerry O'Brien5h 34m Beginner
2. SQL Server Integration Services Tools
3. SQL Server Integration Services Tasks
4. Data Flow
5. Variables, Parameters, and Expressions
6. Performing Joins
7. Debugging SQL Server Integration Services Packages
8. Common Designs in SQL Server Integration Services
Where to go next37s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.