get the app get the app       get the app       get the app
You work as a database administrator at Abc.com. 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.


  • : 202
  • : 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

    Close(X)
    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