Click on a date to enlist yourself for this course or click here if no suitable date can be found.
Prerequisites
Exposure to enterprise data import and export scenarios.
Experience navigating the Microsoft Windows Server environment.
Experience with Microsoft SQL Server, including:
-SQL Server Agent
-SQL (SELECT, UPDATE, INSERT and DELETE)
-SQL Server accounts (users and permissions)
Dimensional Modeling for the Data Warehouse (DMDWH)
Writing Queries using Microsoft SQL Server 2008 Transact SQL (MS2778)
Course outline
In this three-day instructor-led course you will learn how to implement a scalable and maintainable ETL solution with Integration Services. You will learn how to develop, deploy, and manage Integration Services packages.
Course content
Overview of Integration Services Solutions
Using Integration Services tools
Creating, building and running an Integration Services solution
Control Flow: Tasks, precedence constraints and containers
Data Flow: Sources, destinations, paths and transformations
Implementing Integration Services logging
Implementing Checkpoints and Transactions
Configurations and deployment
Managing and Securing Packages
Related courses
Implementing and Maintaining SQL Server 2008 Analysis Services (MS6234)
Implementing and Maintaining SQL Server 2008 Reporting Services (MS6236)
More information
For more information about our training solutions and the other services of our Knowledge Center,
contact us by phone: For The Netherlands +31 (0)318 - 50 11 19 - For Belgium +32 (0)15 - 28 63 70 or via e-mail: For The Netherlands: training.nl@infosupport.com, for Belgium training.be@infosupport.com
