After deploying my SSIS package into our production server running what I
think is a 64 bit version of SQL Server Integration Services, I am unable to
execute the package. During validation I get the error:
Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
I have already Run64BitRuntime property to false in both the SSIS package
and the deployment bundle. I am at a loss how to proceed.
Any assistance is welcome.
How did you execute your package? I recommend that you try using dtexec.exe
to run your SSIS package to see if this issue exists.
From my research, there are some similar issues which are related to
missing specifying password or encrypted password. If the package
encryption level is EncryptSensitiveWithPassword or EncryptAllWithPassword,
use the Decrypt option to provide the password. If no password is included,
dtexec will prompt for the password.
For more information, please refer to:
How to: Run a Package Using the DTExec Utility http://technet.microsoft.com/en-us/library/ms138023(SQL.90).aspx
NOTE: Our managed newsgroup is focused on break/fix issues that are neither
urgent nor complex. If the issue is urgent to your business, it is
recommended that you contact Microsoft Customer Support Services (CSS) via
telephone so that a dedicated Support Professional can assist you in a more
efficient manner. Please be advised that contacting phone support will be a
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Microsoft Online Community Support
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
This posting is provided "AS IS" with no warranties, and confers no rights.