Share via


SSIS Tutorials / Hand-on Labs

 

Tutorials/ Hands-On Labs Business Intelligence:

Integration Services Virtual Lab After completing this lab, you will be better able to:

1. Create a SQL Server 2005 Integration Services (SSIS) package

2. Create an SSIS package project Monitor the progress of an SSIS package

3. Log results from an SSIS package to both a text file and the Windows Event log

https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032323416&EventCategory=3&culture=en-US&CountryCode=US

Hands-on Training for SSIS (SQL Server Integration Services) Contains a Microsoft Word lab Document, sample files to process, and a sample DB, all of which support a series of exercises which guide a reader/user through step by step creating SSIS (SQL Server Integration Services) packages. Lab document includes commentary and by completion of the exercises a user will have a good understanding of what can be accomplished with SSIS as well as how to create some simple SSIS packages.

https://www.microsoft.com/downloads/details.aspx?FamilyID=B1145E7A-A4E3-4D14-B1E7-D1D823B6A447&displaylang=en

SQL Server Integration Services (SSIS) Hands on Training - Creating Custom Components This manual is was presented as a hands on training lab which walks users through Step by Step, creating a sample Custom Component\Transformation for SQL Server Integration Services (SSIS).

https://www.microsoft.com/downloads/details.aspx?familyid=1C2A7DD2-3EC3-4641-9407-A5A337BEA7D3&displaylang=en