July 30, 2018 at 4:50 pm
SSIS package fails in between when there is an unplanned failover in alwayson
How do we make sure that it runs fine during an failover?
July 31, 2018 at 12:46 pm
SQLAddict01 - Monday, July 30, 2018 4:50 PMSSIS package fails in between when there is an unplanned failover in alwayson
How do we make sure that it runs fine during an failover?
You can't. if the fail over happens while the package is running you will lose the connection to that database hence the package will fail, the connection doesn't stay alive, it's not like the windows server or the sql server keeps your connection in memory or something like that. You'll have to re-connect or re-run the package so it can connect to the new database.
What i said earlier will work as long as your package is aiming to the DNS listener created while making the AG.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply