Integration Services (SSIS), the next generation of the Extract, Transport, and Load (ETL) feature included with
Microsoft SQL Server 2005 has befuddled Database Administrators. This is due to the new programming paradigm
and the complexity of the development environment. SSIS includes many new capabilities bundled with a
Visual Studio front end. This paper explores the creation of sample development data featuring the use of the
most basic features in this new interface. The challenge of declaring and passing package variables contains
enough material for an hour’s skill-building session with this new tool....