I'm having trouble running the package installation to move my packages onto the SQL Server.
I'm running SQ2005 64bit. I have 3 connections, 2 to ACCESS and 1 to the SQL Server. I have both the package ProtectionLevels set to EncryptSensitiveWithPassword.
It runs fine in BIDS w/o a package configuration. When I compile and try to install the manifest to the server it doesn't connect to the SQL Connection saying that the User can't login in (It's not passing the password).
If I add a package configuration it doesn't run anymore w/in BIDS and I get error when trying to run the manifest saying that it won't connect to the ACCESS DB's.
Any help would be appreciated. I'm pulling my hair out here!
I'm running SQ2005 64bit. I have 3 connections, 2 to ACCESS and 1 to the SQL Server. I have both the package ProtectionLevels set to EncryptSensitiveWithPassword.
It runs fine in BIDS w/o a package configuration. When I compile and try to install the manifest to the server it doesn't connect to the SQL Connection saying that the User can't login in (It's not passing the password).
If I add a package configuration it doesn't run anymore w/in BIDS and I get error when trying to run the manifest saying that it won't connect to the ACCESS DB's.
Any help would be appreciated. I'm pulling my hair out here!