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