SQL Server Integration Service is a platform to design the complete ETL process. It support almost all types of data sources, destinations and all possible transformation activities on data. It provide the flexibility to design, debug and deploy a simple copy table task to quite complex data transformation project. SSIS packages are designed in SQL Server Business Intelligence Development Studio (BIDS). So let us take an overview of main elements of BIDS for Integration Services project.
• The control flow elements —tasks and containers—for building the control flow in a package. Control flow elements prepare or copy data, interact with other processes, or implement repeating workflow. Precedence constraints sequence the control flow elements into an ordered control flow and specify the conditions for executing tasks or containers.
• The data flow components —sources, transformations, and destinations—for building data flows in a package that extract, transform, and load data. Paths sequence the data flow components into an ordered data flow.
• The connection managers that connect to different types of data sources to extract and load data.
• The variables that can be used in expressions to dynamically update column values and property expressions, control execution of repeating control flows, and define the conditions that precedence constraints apply.
• The event handlers that run in response to the run-time events that packages, tasks, and containers raise.
• The log providers that support logging of package run-time information such as the start time and the stop time of the package and its tasks and containers.
No comments:
Post a Comment