Can you please elaborate? Do you mean cluster failover or failover of a specific database with database mirroring? Do you want the package to initiate failover, to be run once after failover, or run against the correct server/database after failover?
Ole Kristian Velstadbråten Bangås -
Virinco -
Facebook -
TwitterConcatenating Row Values in Transact-SQL[/url]