SQL Server
 
 
 

Using SSIS (SQL Server Integration Services)


Course ID: 1111
Format: Hands-On and Lecture
Duration: 2 days
 
 
  Course Prerequisites:
This course is intended for participants who have some exposure to programming and are interested in a course for designing and developing applications using SQL Server Integration Services (SSIS).
 
Who Should Attend:
This course is intended for programmers, Systems Analysts, and other IT professionals who require an an understanding of how SQL Server Integration Services (SSIS) works.
 
Course Description:
Using SSIS (SQL Server Integration Services) provides the participant with the knowledge and skills necessary to successfully design, develop and deploy efficient & manageable ETL solutions for various applications that rely on SQL Server using SSIS, including Data Warehouse and BI applications.
 
Course Objectives:
At the end of the course, participants will be able to:
  • SSIS features and functionality
  • How to use SSIS to process fact & dimension tables in a data warehouse/business intelligence application
  • How to design, develop and deploy SSIS solutions.
  • Best practices for designing and implementing SSIS solutions.
  • Performance tuning techniques.
 
Topics:
  • Overview of SSIS   
  • The role of SSIS in data warehousing/business intelligence   
  • ETL processing & SSIS ETL features   
  • SSIS Architecture   
  • SSIS Tools and Utilities   
  • SSIS Objects and Concepts (including packages, control flows, data flows, precedence constraints, variables, event handlers, log providers)   
  • Creating SSIS Packages using BIDS   
  • Creating SSIS Packages using Visual Studio   
  • SSIS Package Objects   
  • Executing an SSIS Package   
  • Control flow objects including tasks, containers & precedence constraints   
  • Data flow objects including transformation objects, data sources, data destinations   
  • Data Warehousing with SSIS   
  • Extracting data with SSIS   
  • Data sources & data source views   
  • Connection managers   
  • Full & incremental data extraction   
  • Extending SSIS functionality with scripting   
  • Debugging   
  • Using Package Configurations   
  • Deployment   
  • Logging