|
-
Sep 13th, 2012, 02:21 PM
#1
Thread Starter
Addicted Member
SSIS Encryped Password Issue
Here's my situation:
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|