You are designing a SQL Server 2008 Integration Services (SSIS) package. The package
will be used to extract data from a SQL Server 2008 database and load data to a Microsoft
Office Excel workbook. You need to ensure that the package creates a new worksheet in an
existing Excel workbook during execution. Which control flow component should you use to
create the worksheet?
A.
File System Task
B.
Execute SQL Task
C.
Data Flow Task along with the OLE DB source
D.
Bulk Insert Task
Explanation:
Data flow tasks within SSIS can be used to move data from a source to destination and at
the same time use certain transformation tasks to clean and modify the data while it is
transferred. By adding a data flow task to the package control flow the package can be made
to perform data extraction, transformation and load (ETL) operations.
A: File System Task is used to perform operations on files and folders, such as create,
move, delete, and also to set the attributes for files and folders.
B: The Execute SQL Task can be used to execute any TSQL code
D: The Bulk Insert Task can be used to insert data from a text file or a flat file into a SQL
Server Table