2008.3

This session will provide beginners with an overview of SQL Server Integration Services 2005.  I’ll show you how I used table-driven parameters, package variables, collections, expressions, Execute SQL tasks, loops, and the Bulk Insert and File System tasks to build the Extract, Transform and Load (ETL) process for a small to mid-size data mart.

Melissa Demsak has been working as a SQL Server Developer specializing in Business Intelligence and Data Warehousing for 10 years.  She currently works for Realogy as a SQL Architect on the NRT Finance MIS Team.  In 2006, Melissa founded the NJ SQL Server User Group (www.njsql.org).  Melissa is also an active PASS volunteer and has been on the Business Intelligence Program Committee that is charged with selecting/reviewing topic for the yearly PASS Summit conference for the last two years.