You work as a database administrator at You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow. The SSIS data flow will transfer data to a SQL Server 2008 database named CKProducts. You want to ensure that the data flow refreshes the existing data in CKProducts with the data in the data flow. What should you do?

1)You should use the OLE DB Destination.

2)You should use the SQL Server Destination.

3)You should use a Data Conversion Transformation.

4)You should use the Fuzzy Grouping Transformation.

  • : 390
  • : 19
    Previous Next

    You should use the SQL Server Destination.

    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