SQL Server Integration Services Essentials
Course Code: SSISE
Course Duration: 1 Day
Overview
This one-day hands-on, instructor led course guides you through
the numerous features of SQL Server Integration Services (SSIS)
using real-world exercises structured around every component within
Business Intelligence Development Studio. You will be introduced to
MDX and learn a practical approach to solving real-world problems
using SSIS, which will provide you the ability to collect
enterprise data from various sources such as SQL Server OLTP
databases, Access databases, Excel worksheets and more, and
transform the data for OLAP analysis, mining, and reporting. You
will take home many useful examples to adapt to your own
environments.
Who Should Attend
This course is designed for anyone who wants to use SQL Server
Integration Services (SSIS) to develop extract, transform or load
solutions and wants to gain a greater understanding of MDX. This
includes developers and database administrators, business analysts
and anyone that designs and builds ETL solutions.
Course Objectives
After completing this course, students will be able to:
- Create well-designed Business Intelligence solutions using
Business Intelligence Development Studio (BIDS)
- Extract, transform, and load (ETL) data from disparate
sources
- Build packages with the easy-to-use SSIS Import and Export
Wizard and the Visual Studio based BIDS
- Become familiar with SSIS package management and package
deployment
- Implement robust logging and error handling
- Develop best practices that will make it easier to develop and
maintain a package over its entire life cycle
- Have sufficient experience to tackle an SSIS project with
confidence
Course Prerequisites
Before attending this course, participants should have:
- An understanding of SQL Server 2008
- Experience in creating, retrieving, updating and deleting
queries using T-SQL
- Ideally know how to connect to an instance of SQL Server 2008
using the various connection dialog boxes in Management Studio and
development tools