You will learn about the SQL Server Data Tools (SSDT) development

environment to create SSIS projects and packages, work with control

flow tasks and design data flows using various transformations and

data sources/destinations (including SQL Server databases, flat files

and Excel). We also cover SSIS project and package management,

deployment, debugging, error handling and logging techniques. Our

training is enriched by illustrated examples and practical exercises.

 

Delegates should ideally be familiar with basic programming concepts

and understand the fundamental design of relational databases and

data normalisation. Some prior working knowledge of SQL Server 2017

(or earlier), and the use of SQL Server Management Studio, is assumed,

along with knowledge of the SQL query language, in particular the

SELECT, UPDATE, INSERT and DELETE statements.

• Understand the role SQL Server Integration Services plays in business intelligence

• Create and develop integration services projects and packages in SSDT

• Understand and implement control flow tasks

• Understand and implement data flow transforms and components

• Implement logging

• Debug and implement error handling

• Implement checkpoints and transactions

• Deploy Integration Services projects and packages

• Manage and secure Integration Services projects and packages

• Understand basic data warehousing concepts

• Manage changing data with the SSIS CDC components