Microsoft
70-448 · Question #176
You are creating a SQL Server 2008 Integration Services (SSIS) package which gets information from a FTP server through utilizing many FTP tasks and operate information through utilizing many…
The correct answer is D. You should set the package to utilize a checkpoint. See the full explanation below for the reasoning.
Question
You are creating a SQL Server 2008 Integration Services (SSIS) package which gets information from a FTP server through utilizing many FTP tasks and operate information through utilizing many Execute SQL tasks for Company.com. After the package downloads the files, you should make sure that you could set the package to restart. In order to solve the problem, which is the correct answer?
Options
- AYou should set the HTTP tasks to hold transactions Log.
- BYou should set the Execute SQL store procedure to hold transactions Log.
- CYou should transfer the half HTTP job to a sequence container.
- DYou should set the package to utilize a checkpoint.
How the community answered
(37 responses)- A5% (2)
- B11% (4)
- C3% (1)
- D81% (30)
Community Discussion
No community discussion yet for this question.