Control Flow Tasks in Detail

In the previous section, you’ve read brief description of each task, you’ll work through Hands-On exercise or read about the options available through the task’s GUI now. While working through the details of each task and Hands-On exercise, you will not follow the categorization flow. This is done intentionally to make it easier to learn and work with the tasks for business scenarios, followed by intuitive and step by step methods.

Your first project will require that you download, expand, and archive these zipped files, and then import them to a SQL Server table. This is a simple but generic scenario we all encounter in our day-to-day job functions. The solution to the scenario will be explained in all the Hands-On ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.