This very focused 3-day instructor-led 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 students will learn how to use SQL Server Data Tools (SSDT) to create SSIS packages to extract, transform, and load (ETL) data using a variety of data sources, transformations, and destinations. They will also understand SSIS package management and package deployment with the new SSISDB Package Catalog. They will also learn how to write solid code using debugging, error handling, and logging techniques. Note: since there were no changes to SSIS between SQL Server 2014 and SQL Server 2016, students working with both versions can attend this course. While this course also assumes no prior knowledge of SQL Server Integration Services, this course does assume some prior knowledge of SQL Server 2014 or newer and the use of SQL Server Management Studio (SSMS) for development and administrative tasks. Students should be able to create simple CRUD (create, retrieve, update and delete) queries using T-SQL, understand basic relational databases design, run script files and diagnose problems that occur. Participants should also know how to connect to an instance of SQL Server 2014 using the various connection dialog boxes in SSMS and SSDT.
What You'll Learn
- The new SSIS features that were released with SSIS 2014/2016
- The challenges and solutions to running packages in x86 and x64 environments
- The problems and solutions encountered when upgrading SSIS 2005/2008 packages to SSIS 2012/2014
- How to use SSDT to create and debug 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 variables and the new SQL Server 2014 parameters that make packages dynamic and resilient to change in environments
- About the features in SSDT and Integration Services that help developers troubleshoot packages
- How to schedule SQL server Agent to run packages automatically
- How to deploy and manage packages effectively, including the new SSISDB Package Catalog
- How to write and debug script so that they can go beyond the built-in tasks, data sources, transformations, and destinations
- 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
- Course Number SSIS3
- Course Length 3 days
- Course Fee $2,195.00
- Delivery Format VLT (Instructor Led; Virtual LIVE Online; Remote Training)
- Course Topic Business Intelligence
- Vendor Microsoft
- Technology SQL Server
Register for course: SSIS3
"*" indicates required fields