You plan to use SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 failover
cluster. You have a complex package that takes a long time to run. You need to ensure that
if the package executes during a failover, the package can be resumed at the point of failure.
What should you do?
A.
Cluster the SSIS service. Add the SSIS service to its own cluster resource group.
B.
Cluster the SSIS service. Add the SSIS service to the SQL Server cluster resource group.
C.
Implement checkpoints within your package. Restart the package whenever a failover
occurs.
D.
Implement transactions within your package. Restart the package whenever a failover
occurs.