SSIS Training | SQL Server 2005 Integration Services Training

| More

SQL Server 2008 Integration Services (SSIS) Training

|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.

Course Number
2-A-792

Learning Objectives
During this course students will learn:

How to use Bids to create well-designed packages
About Control Flows, how to build them using many of the built-in tasks, including the various containers
How to use the Data Flow task to perform primary ETL operations
About variable and configurations to make your packages dynamic and resilient to changes in environments
About the features in BIDS and Integration Services that help you troubleshoot a package
How to deploy and manage packages effectively
How to write script so that you can go beyond the built-in taks, data sources and destinations, and transformations, as well as building and using custom components
Best practices that will make it easier to develop and maintain a package over its entire life cycle
About using Integration Services for tasks other than traditional ETL operations

Length
3 Days

Price
$1,795.00

Schedule