Level: Introductory to Intermediate

David Dye

Sergeant

Cape Coral Police Department

Learn the knowledge and tools to immediately begin creating your own SSIS packages in your environment.

Have you ever been asked to export data from a SQL Server database to an Excel spreadsheet or parse an XML file and import data into Microsoft Access or SQL, or connect to an FTP server and import a comma delimited file? If you have been tasked with any of these chores or are required to export or import any data on a daily basis, then SQL Server Integration Services (SSIS) is the answer. SSIS is the toolset used to help you implement data integration process applications among your business application system’s files and databases.

SSIS was first introduced in SQL 2005 as the replacement to Data Transformation Services (DTS) and serves as the primary tool to extract, transform, and load data. Built on top of the Common Language Runtime (CLR) SSIS provides a powerful and extensible platform to meet any ETL process.

This session will cover SSIS from beginning, creating simple to complex SSIS packages, to end, debugging, deploying, and maintaining projects. All demonstrations and examples will be presented using SSIS 2012, but detail will be given throughout the workshop to discuss the differences between SSIS 2005 through 2014. Upon completion, attendees will be armed with the knowledge and tools to immediately begin creating their own SSIS packages in their environment.

You will learn:

• Control flow tasks and architecture
• Primary components of a data flow control flow task
• To implement event handlers for pro-active error handling and custom logging
• To use variables in a package to implement dynamic execution
• Become familiar with the different methods of deployment and the differences of each
• To use parameters to provide a means of making package execution dynamic and portable
• To work with the SSIS catalog to monitor execution and metrics