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.