November 2012
Beginner
528 pages
12h 9m
English
book
Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer
by Brian Knight, Devin Knight, Mike Davis, Wayne Snyder
Content preview from Knight's Microsoft SQL Server 2012 Integration Services 24-Hour TrainerBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Section 2
Control Flow
- Lesson 9: Using Precedence Constraints
- Lesson 10: Manipulating Files with the File System Task
- Lesson 11: Coding Custom Script Tasks
- Lesson 12: Using the Execute SQL Task
- Lesson 13: Using the Execute Process Task
- Lesson 14: Using the Expression Task
- Lesson 15: Using the Send Mail Task
- Lesson 16: Using the FTP Task
- Lesson 17: Creating a Data Flow
Chapter 9
Using Precedence Constraints
When using tasks in SQL Server Integration Services (SSIS), you need a way to connect these tasks in most cases. Precedence constraints are the connections between the tasks that control the execution order of each task. After you drag in more than one task in the Control Flow in SSIS, you can link them together by using these precedence constraints. Click once on a task, and you see a green arrow pointing down from the task; this is the precedence constraint line for this task. For example, in Figure 9-1, you can see a Script Task with a green arrow below the task. This is the precedence constraint arrow to connect to the next task you need to run after this task completes successfully. These arrows control the order of tasks in a package, and they also control whether tasks will run at all.
To create an On Success Precedence Constraint, click ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.