I have 2 app servers. I setup my SSIS packages on the D:\ drive of one of the servers. If one server goes down the D:\ drive moves to the other server as a failover. The packages work fine on server 1. If I shut down server 1 the d:\ drive moves to server 2 as expected. The problem is the packages then do not work on server 2. I receive a password encryption error when I try to open them. If I then go ahead and save the package on server 2 and shut down server 2, the d:\ drive moves back to server 1. Server 1 then cannot execute the packages.
Seems like it won't execute the packages on a machine other than the one the packages were saved on. Does anyone know a way around this for my scenario? Thanks.