You are developing a SQL Server 2008 Integration Services (SSIS) data flow that loads data
to a SQL Server 2008 database.
You need to ensure that the data flow updates the existing records in the SQL Server
database by using data from the rows in your data flow.
Which data flow component should you use?
A.
OLE DB Destination
B.
SQL Server Destination
C.
Data Conversion Transformation
D.
OLE DB Command Transformation
Explanation:
Destinations are the data flow components that load the data in a data flow into different
types of data sources or create an in-memory dataset. Note 1: SQL Server Integration
Services provides three different types of data flow components: sources, transformations,
and destinations. Sources extract data from data stores such as tables and views in
relational databases, files, and Analysis Services databases. Transformations modify,
summarize, and clean data. Destinations load data into data stores or create in-memory
datasets. Note 2: The Data Flow task encapsulates the data flow engine that moves data
between sources and destinations, and lets the user transform, clean, and modify data as it
is moved. Addition of a Data Flow task to a package control flow makes it possible for the
package to extract, transform, and load data. A data flow consists of at least one data flow
component, but it is typically a set of connected data flow components: sources that extract
data; transformations that modify, route, or summarize data; and destinations that load data.
Components are connected in the data flow by paths. Each path specifies the two
components that are the start and the end of the path.