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
....etc.
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.
Thanks
Hi,
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
charged call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Best regards,
Charles Wang
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.
======================================================