70-448 · Question #202
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…
The correct answer is C. Data Flow Task along with the OLE DB source. 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…
Question
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?
Options
- AFile System Task
- BExecute SQL Task
- CData Flow Task along with the OLE DB source
- DBulk Insert Task
How the community answered
(42 responses)- A10% (4)
- B2% (1)
- C83% (35)
- D5% (2)
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
Topics
Community Discussion
No community discussion yet for this question.