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?
A.
You should set the HTTP tasks to hold transactions Log.
B.
You should set the Execute SQL store procedure to hold transactions Log.
C.
You should transfer the half HTTP job to a sequence container.
D.
You should set the package to utilize a checkpoint.