6:00 – 6:30 Pizza and Networking

6:30 - 6:40 Announcements

6:40 – 7:00 Ken McClaren : SQL Server Certification

7:00 – 8:15 John Welch : Doing More (ETL) with Less (Effort) by Automating SSIS

8:15 – 8:30 Closing remarks and give-a-ways

SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you'll learn how to automate data transfers from a source to a target using SSIS. You’ll see the steps necessary to create both the control flow and the data flow portions of an SSIS package using the API and C# code. You’ll also learn about altering existing packages programmatically. Specific attention will be given to the generation of data flows with the proper source and destination components. We’ll take a look at some of the open source solutions available for this, plus some “roll your own” options.

Takeaways:

1.       Generating Control Flow Tasks through the API

2.       Generating Data Flow Components through the API

3.       How to Alter Existing Packages Programmatically

John Welch is Chief Architect with Mariner, a consulting firm specializing in enterprise reporting & analytics, data warehousing and performance management solutions. John has been working with business intelligence and data warehousing technologies for 7 years, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), an award given due to his commitment to sharing his knowledge with the IT community.  John is an experienced speaker, having given presentations at Professional Association for SQL Server (PASS) conferences, the Microsoft Business Intelligence conference, Software Development West (SD West), Software Management Conference (ASM/SM), and others. He has also contributed to two recent books on SQL Server 2008, “Microsoft SQL Server 2008 Management and Administration” and "Smart Business Intelligence Solutions with Microsoft SQL Server 2008".

John writes a blog on business intelligence topics at http://agilebi.com/cs/blogs/bipartisan. He also writes one focused on SSIS topics at http://agilebi.com/CS/blogs/jwelch/. He is also active in open source projects that help ease the development process for Microsoft BI developers, including BIDS Helper (http://www.codeplex.com/bidshelper), an add-in for Business Intelligence Development Studio that adds commonly needed functionality to the environment. He is also the lead developer on ssisUnit (http://www.codeplex.com/ssisUnit), a unit testing framework for SSIS.