get the app get the app       get the app       get the app

Question: 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 and inserts the updated records into the SQL Server database by using data from the rows in your data flow.

Which three data flow components should you use? (Each correct answer presents part of the solution. Choose three.)

1)Conditional Split Transformation
2)OLE DB Destination
3)OLE DB Command Transformation
4)Data Conversion Transformation
5)Lookup Transformation

Previous Next

Suggest other answer
Login to Discuss/suggest the answer...

Exam Exam: 70-448 MS SQL Server 2008, Business Intelligence

Recommended Learning for you

Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material