Shared Flashcard Set

Details

SSIS 2014
SQL Server Integration Services 2014
10
Computer Science
Professional
04/24/2015

Additional Computer Science Flashcards

 


 

Cards

Term
Package
Definition
A collection of tasks snapped together with precidence contraints used to execute functionality in an orderly fashion.
Term
Precedence Contraint
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
Container
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
Task
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
Data Flow Task
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
SSIS
Definition
SQL Server Integration Services
Term
OLE DB
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
Transformation
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
SSDT
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
BIDS
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).
Supporting users have an ad free experience!