Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

DTS_E_CANNOTACQUIRECONNECTIONF ROMCONNECTIONMANAGER


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.
======================================================

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc