You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com.
You decide to utilize SQL Server 2008 Integration Services (SSIS) on a SQL Server 2008 failover cluster.
You own a complex package which costs too much time .
You should make sure that the package could be restored if the package runs during a failover.
Which is the correct answer?
A.
Before restarting the package whenever a failover happening you should run store procedure in your package.
B.
You should increase the SSIS service to the SQL Server cluster resource group.
C.
Before restarting the package whenever a failover happening you should run checkpoints in your package.
D.
Before restarting the package whenever a failover happens you should run transactions in your package.