Thursday, May 20, 2010

SSIS Terminologies

SSIS - SQL SERVER Integration Services (since SQL SERVER 2005) previously named as DTS - Data Transformation Services

SSIS is an ETL application - Extraction Transformation Load
BIDS is the Development tool - Business Intelligence Development Studio
Package - Product that SSIS produces
Control flow - Workflow of a package
Data flow - Movement of data in a package
Task - Individual Unit of Work
Transform - Individual Unit of Work in a data flow
Event Handler - Handle errors, warnings or events.

No comments:

Post a Comment