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…

Question

Options

• AOLE DB Destination
• BSQL Server Destination
• CData Conversion Transformation
• DOLE DB Command Transformation

• A
  2% (1)
• B
  80% (33)
• C
  5% (2)
• D
  12% (5)

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 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, 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.

No community discussion yet for this question.