Microsoft SSIS Online Training Hyderabad India

Click Here For Course Content.

SSIS: SQL Server Integration Services Course Content


Introduction to SQL Server Integration Services


  • Product History
  • SSIS Package Architecture Overview
  • Development and Management Tools
  • Deploying and Managing SSIS Packages
  • Source Control for SSIS Packages

SSIS for DBAs: Using SQL Server Management Studio


  • The Import and Export Wizard
  • Importing and Exporting Data
  • Working with Packages
  • Database Maintenance Plans
  • Creating Database Maintenance Plans using SSMS
  • Scheduling and Executing Plans Examining Database Maintenance Plan Packages

Business Intelligence Development Studio


  • Launching BIDS
  • Project templates
  • The package designer
  • The Toolbox
  • Solution Explorer
  • The Properties window
  • The Variables window The SSIS menu

Introduction to Control Flow


  • Control Flow Overview
  • Precedence Constraints
  • The Execute SQL Task
  • The Bulk Insert Task
  • The File System Task
  • The FTP Task
  • The Send Mail Task

Advanced Control Flow


  • Containers  grouping and looping
  • The Web Service Task
  • The WMI tasks
  • The Analysis Services tasks
  • The Execute Process Task The Execute Package Task

Introduction to Data Flow


  • Data Flow Overview
  • Data Sources
  • Data Destinations
  • Data Transformations
  • The Copy Column Transformation
  • The Derived Column Transformation
  • The Data Conversion Transformation
  • The Conditional Split Transformation
  • The Aggregate Transformation
  • The Sort Transformation
  • Data Viewers

Variables and Configurations


  • Variables Overview
  • Variable scope
  • SSIS system variables
  • Using variables in control flow
  • Using variables in data flow
  • Using variables to pass information between packages
  • Property expressions
  • Configuration Overview
  • Configuration options

Debugging, Error Handling and Logging


  • SSIS debugging overview
  • Breakpoints in SSIS
  • SSIS debugging windows
  • Control Flow: The on Error event handler
  • Data Flow: Error data flow
  • Configuring Package Logging Built-in log providers

Advanced Data Flow


  • Revisiting data sources and destinations
  • The Lookup Transformation
  • Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
  • The Multicast Transformation
  • The Merge and Merge Join Transformations
  • The Data Mining Query Transformation
  • The Data Mining Model Training Destination
  • The Slowly Changing Dimension Transformation

Extending SSIS through Custom Code


  • Introduction to SSIS scripting
  • The SSIS script editor
  • The SSIS object model
  • Script in Control flow: The Script Task
  • Script in Data flow: The Script Component
  • Introduction to SSIS component development

SSIS Package Deployment


  • Configurations and deployment
  • The deployment utility
  • Deployment options
  • Deployment security
  • Executing packages DTExec and DTExecUI

SSIS Package Management


  • The SSIS Service
  • Managing packages with DTUtil
  • Managing packages with SQL Server Management Studio
  • Scheduling packages with SQL Server Agent

SSIS 2012 new features


  • CDC (Change data capture) control Flow & Data flow task
  • SSIS Catalog Reports (Dashboard)
  • Package upgrades from legacy to SSIS 2012

Training Enquiry

If you are unable to reach our contact number, Please fill the above Enquiry Form, otherwise send an email to sudeeponlinetraining@gmail.com for quick response.