SQL Server 2008 Integration Services
| Course code: |
SQLSSIS |
| Details: |
24 February, 1 days, £500 + VAT
27 April, 1 days, £500 + VAT
|
| Onsite | Enquire about bringing this course to your offices |
| Who should attend: |
Delegates who are looking to improve their understanding of ETL with SSIS |
| Prerequisite skills: |
Delegates should have some basic knowledge of SQL language queries and experience using SSIS. |
Course Outline
Microsoft SQL Server Integration Services (SSIS) is a key Business Intelligence component of Microsoft SQL Server 2008 / SQL Server 2008 . It supersedes Data Transformation Services (DTS).
The main function of SQL Server Integration Services is Data Warehousing...SSIS allows you to build data integration and workflow applications, and includes commercial-class features for data extraction, transformation, and loading (ETL).
SSIS can also be used for automating maintenance of SQL Server databases, update multidimensional cube data.
Because of the similarities in architecture and functionality between SQL Server 2005 and SQL Server 2008, demonstrations and course labs will either be on SQL 2005 or SQL 2008 with any specific differences being demonstrated where necessary (usually in a short session at the end of each session).
Course Content
This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email sales@jbinternational.co.uk
Advanced SQL Server 2005 / 2008 Integration Services Training Course Outline
SSIS features for SSAS cubes
Fuzzy matching
Derived columns
Slowly changing dimension wizard
SSAS processing
SSAS XMLA
SSIS features for SSAS data mining models
SSAS DMX queries
Percentage and row sampling
Advanced tools
Comprehensive control flow and data
flow toolboxes tour
WMI DataReader
WMI EventWatcher
Web services
Advanced features
Checkpoints
Transactions
Debugging
SQL Server Compact destinations
XML sources
SSRS reports on SSIS packages
rsReportServer.config
rsReportDesigner.config
DataReader destination
Deployment and configuration
Deploying to files and SQL Server
Configuration files
Configuration during deployment
Configuration at run-time
Administration
Package security
Backing up packages
Reverse engineering packages
