I use SQL Mirroring as my DR option. I don't use SAN and therefore clustering is not an option for me. I use Synchronous Mirroring with a witness server, so failover is automated. The principal server also hosts SSIS packages. My objective is that if the witness server does the failover, then the SSIS package should also failover and start executing on Mirror server. How can this be done?

http://support.microsoft.com/kb/942176 . It says "You can use any of the following high availability options against user databases, but not for system databases such as MSDB: Replication Log shipping Database mirroring Therefore, we do not support using these options to obtain high availability for the SSIS packages that are stored in the MSDB database. Instead of clustering the SSIS service, you can cluster the SQL Server service or the SQL Server Agent service to obtain high availability for SSIS packages." http://deepaksqlmsbusinessintelligence.blogspot.com/ Happy to help! Thanks. Regards and good Wishes, Deepak.

I believe that you're going to have to recreate them at the DR site manually.

> I believe that you're going to have to recreate them at the DR site manually. Even if I create them manually at the DR site. How do I activate the job when the witness server does the failover? > you can cluster the SQL Server service or the SQL Server Agent service to obtain high availability for SSIS packages. Deepak, your answer doesn't make any sense because I told you that I don't use shared storage and therefore clustering is out of scope because clustering requires shared storage.