What action should you perform to achieve this goal?

You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.

Now you are employed in a company which is named NaproStar and work as a developer of a SQL Server 2008 Integration Services (SSIS) package for the company.
From a remote FTP server, the package uses multiple FTP tasks to download several files, and then uses multiple Execute SQL tasks to process data.

Now you get an order from your company CIO, according to his requirement, when the package fails to download the files, you need to restart the package by configuring it.
What action should you perform to achieve this goal?

You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.

Now you are employed in a company which is named NaproStar and work as a developer of a SQL Server 2008 Integration Services (SSIS) package for the company.
From a remote FTP server, the package uses multiple FTP tasks to download several files, and then uses multiple Execute SQL tasks to process data.

Now you get an order from your company CIO, according to his requirement, when the package fails to download the files, you need to restart the package by configuring it.
What action should you perform to achieve this goal?

A.
You should have all the FTP tasks moved to a sequence container

B.
You should configure the package by using a checkpoint

C.
You should have the FTP tasks configured to support transactions

D.
You should have the Execute SQL tasks configured to support transactions

Show Hint