Term
|
Definition
| A collection of tasks snapped together with precidence contraints used to execute functionality in an orderly fashion. |
|
|
Term
|
Definition
| A package compnent that is used to connect tasks together. These define how execution will proceed. They are defined based on how the prior task completes. They include: Success, Completion and Failure. |
|
|
Term
|
Definition
| A unit within a SSIS package that allows you to group tasks. There are for types: Task Host (Not visisble), Sequence, For Loop, Foreach Loop. |
|
|
Term
|
Definition
| An individual unit of work. Similiar to methods in procedural programming. A user will drag and drop these on a design surface and configure them to define functionality. |
|
|
Term
|
Definition
| This specialized task loads, transforms and saves data. This task mainly consists of a OLE DB or ADO source, transformations and an OLE DB or ADO desitination. This task is performed in memory, and is typically faster than using staging tables and stored procedures. |
|
|
Term
|
Definition
| SQL Server Integration Services |
|
|
Term
|
Definition
| Object Linking and Embedding. A design originatating from Microsoft COM. It is Microsoft's low-level API for access to different data sources. |
|
|
Term
|
Definition
| A step within a Data Flow Task that modifies the data from a data source. This component type includes: Aggregate, Derived Column, Merge, Sort. |
|
|
Term
|
Definition
| SQL Server Data Tools. A subset of Visual Studio 2013. In previous versions of SQL Server this was called Business Intelligence Development Studio (BIDS). |
|
|
Term
|
Definition
| Business Intelligence Development Studio. This IDE was built within Visual Studio 2008. It was renamed in SQL 2012 as SQL Server Data Tools (SSDT). |
|
|
