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?
A.
Configure the FTP tasks to support transactions.
B.
Configure the Execute SQL tasks to support transactions.
C.
Move all the FTP tasks to a sequence container.
D.
Configure the package to use a checkpoint.