Setup and Congfiguration

In this Tutorial, we are explaining about SSIS by using following sample Databases.

1. SSIS Training Database - Download
2. SSIS Logging Database - Download

• Installation

1. Download the zip file from the download link given above.
2. Extract the zip file to the root c:\ so you end up with “C:\_SSIS_Training”.
3. Attach the following 2 databases. “SSISLOGGING.mdf” for audit and logging data (tables myfileaudit and ssis_ErrorRows) and database “SSISTRAINING.mdf” (tables mydescriptions) for data destination.
4. We will be using data from the AdventureWorks which ships with SQL 2005 (optional during installation)

• Sql Server Books Online (BOL)

1. The BOL topics noted through the doc with the icon above were found with BOL filtered to just search the “Technology” Integration Services, from the BOL Search Page.

• Miscellaneous

1. You may want to have a soft copy of this manual, which can be handy to have open while you do the labs, to allow you to copy/paste expressions from the manual to the Visual Studio design environment.