Database Reference
In-Depth Information
Put down the root beer, though, because you aren't quite done. Continue with these steps:
28.
Go back to the Control Flow tab, and connect the first data flow task to the
second data flow task, and connect the second and third data flow tasks.
29.
Double-click the second data flow task, and do the same thing you did for the
first data flow beginning in step 12. You don't need to re-create the
connections, but in the Source and Destination Editors for the second data
flow, select the Users table.
Repeat the process for the third data flow task, this time selecting the
UserDocs table.
When you're finished, your control flow task should look like Figure 5-15. The tasks aren't green
(yet), but the flow should be similar.
30.
Figure 5-15.
Successful execution of an SSIS package
