You work as a database administrator for ABC.com. The ABC.com network contains a SQL
Server 2008 Integration Services (SSIS) Data Flow.
You configure the data flow to transfer data to a SQL Server 2008 database named ABC_Data.
You have been tasked with configuring the information located in the data flow to refresh the
information in ABC_Data.
How can this be accomplished?
A.
Data Viewer object should be used.
B.
SQL Server Destination should be used.
C.
DBCC SHRINKFILE should be used.
D.
Fuzzy Grouping Transformation should be used.