You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. You need to import data from several comma-delimited lists into a SQL Server 2005 database server named Certkiller -DB02. You need to use a SQL Server Integration Services (SSIS) package to accomplish this task. To this end you are designing the Data Flow elements that will define the importing of data from comma-delimited lists. You need to make a choice regarding the Data Flow elements that should be used in the Destination – Data Flow step.
What should you do?
A.
Use the Raw File Data Flow element.
B.
Use the DataReader Data Flow element.
C.
Use the Bulk Insert Data Flow element.
D.
Use the Flat File Data Flow element.
E.
Use the SQL Server Data Flow element.
Explanation:
Data Flow defines sources, transformations and destinations. In this case you should make use of the SQL Server destination. The SQL Server destination is used when you need to transform data and import it into SQL: Server on the computer where the package is run.
Incorrect Answers:
A: Raw File is used when importing data to a column and the data does not require formatting.
B: The DataReader source is used when exporting data to an application that makes use of Active Data Objects (ADO.NET). In this scenario there is no need for ADO.NET connectivity.
C: Bulk Insert task can be added to a Data Flow, however, it does not allow for transformations.
D: The Flat File element is used when importing data from a comma-delimited text file.