You are developing a SQL Server 2008 Integration Services 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?

technology architecture

  1. SQL Server Destination

  2. OLE DB Destination

  3. OLE DB Command Transformation

  4. Data Conversion Transformation

Show answer
Correct Option: C

Find more quizzes: