This course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques.

SQL Training Audience:

SQL Server Users.

SQL Training Prerequisites

This course assumes no prior knowledge of SQL Server Integration Services. This course does assume prior knowledge of SQL Server 2008 and the use of SQL Server Management Studio for development and administrative tasks. You should be able to create CRUD (create, retrieve, update, and delete) queries using T-SQL, understand basic relational databases design, run script files and diagnose problems that occur, and have experience building applications that access data stored in SQL Server. You must also know how to connect to an instance of SQL Server 2008 using the various connection dialog boxes in Management Studio and development tools.

SQL Training Course duration

3 days

SQL Training Course outline

1. A Guided Tour of Integration Services

• Understanding Integration Services
• What is ETL?
• Integration Services Packages
• Tools for Building Integration Services Packages
• Integration Services Package Storage Options
• Creating a Package with the Import and Export Wizard
• Other Ways to Launch the Import and Export Wizard
• Exploring and Executing an Integration Services Package in BIDS
• The BIDS Interface and Components
• Executing a Package in BIDS
• Exploring and Executing a Package Outside of BIDS