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?

Keep practicing — related questions

• Which of the following can be used for the Integration and Migration of data?
• Your SQL Server is running SQL 6.5 and you want to transfer the data from the SQL 6.5 server to a new SQL 7...
• What is the data flow transformation that needs a sorted data stream?
• Which transformation we will use if want to efficiently join two tables residing in same database?
• John Doe has SQL Server 4.2 and she wants to upgrade the server, data and database objects to SQL Server 7....
• You are designing a SSIS package. The package includes a Data Flow Task. You need to modify the package to ...
• You are importing data into SQL server 2005 database. You are receiving text files that contain Sales trans...
• You have been asked to copy a one-table Access database to another table that exists in a SQL Server 7 data...