msbi online training in hyderabad

This service is used to carry out ETL (Extraction, Transform and Load data) and admin operations. The BIDS (Business Intelligence Studio till 2008 R2) and SSDT (SQL Server Data Tools from 2012) are the environments to develop packages.

SSIS Basic Architecture

Solution (Collection of projects) —> Project (Collection of packages) —> Package (Collection of tasks for ETL and admin operations)

Under Package, the following components are available −

  • Control Flow (Containers and Tasks)
  • Data Flow (Source, Transformations, Destinations)
  • Event Handler (Sending of messages, Emails)
  • Package Explorer (A single view for all in package)
  • Parameters (User interaction)