I have a project with about 30 separate Pkgs. Each pkg has 5 connection managers to the same 5 connections. These connections are in a config file and each package is pointing to the same config file. Each time I open the project and then one of the packages, one or more of the connection managers receive the error: > ssis error code > dts_e_cannotacquireconnectionfromconnectionmanager. > the acquireconnection method When I reopen the config file, one or more of the connections is no longer checked to be in the config file. How does this happen? I am a bit confused on all the encrypt/ don't encrypt protection level, True/false delay validation and the 64 vs 32 bit properties that can be set and how that affects connection managers. I can't seem to find consistency for the settings among opinions and answers. Is there a standard from which to start? I have a windows 2003 server with 2005 sql and BIDs. How do I determine if I am running in 32-bit or 64? Is this something set in both sql server, windows server and BIDS?
You've asked a number of questions, so please bare with me: In regards to the encryption, check out:
http://msdn.microsoft.com/en-us/library/ms141747(v=sql.90).aspx. The delay validation refers to when the package loads, by default it will attempt to validate all of the connections in order to make sure that they are present. If you are attempting to do dynamic setting of the connections through code, you'd want to set this flag to TRUE to prevent any validation errors from appearing. The 64/32 bit will refer to where ever you are running the package. If the package is going to run on a 32 bit server, you won't have to change anything. You can determine this by looking at the computer properties of the server. It will tell you if the server is 32 bit or not. If the Windows server is 32 bit, SQL Server will be 32 bit as well. In my environment we don't use dynamic connections so we usually do not turn on Delay validation and we do not change the encryption levels. Was there any additional information regarding the error? I found a couple possible solutions but it would depend on what else was contained within the error. Hope this helps!