Microsoft
70-448 · Question #4
You develop a SQL Server 2008 Integration Services (SSIS) package. The package downloads several files from a remote FTP server by using multiple FTP tasks, and then processes data by using multiple…
The correct answer is D. Configure the package to use a checkpoint. See the full explanation below for the reasoning.
Question
You develop a SQL Server 2008 Integration Services (SSIS) package. The package downloads several files from a remote FTP server by using multiple FTP tasks, and then processes data by using multiple Execute SQL tasks. You need to configure the package to restart at the point of failure after the package downloads the files. What should you do?
Options
- AConfigure the FTP tasks to support transactions.
- BConfigure the Execute SQL tasks to support transactions.
- CMove all the FTP tasks to a sequence container.
- DConfigure the package to use a checkpoint.
How the community answered
(27 responses)- A4% (1)
- B7% (2)
- C15% (4)
- D74% (20)
Community Discussion
No community discussion yet for this question.