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

  • : 324
  • : 9
    Previous Next

    OLE DB Destination

    OLE DB Command Transformation

    Lookup Transformation

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

  • 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