.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Asad Ali
Fauzul Azmi
Post New Web Links

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :Sql Server
 

Can you please give me some guidance on how to resolve this issue??

I have developed a package using 32 bit edition of SQL 2005 bids. I am deploying this on 64 bit SSIS.

I have tried two things.

"c:\program files (x86)\Microsoft SQL Server\90\DTS\Binn\DTEXEC.exe" /SQL "My Package"

Microsoft (R) SQL Server Execute Package Utility
Version 9.00.4035.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started:  8:24:25 AM
Progress: 2010-10-04 08:24:26.33
   Source: Data Flow Task
   Validating: 0% complete
End Progress
Progress: 2010-10-04 08:24:26.33
   Source: Data Flow Task
   Validating: 50% complete
End Progress
Error: 2010-10-04 08:24:26.34
   Code: 0xC0202009
   Source: Import AD Data Connection manager "Destination"
   Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040E21  Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
End Error
Error: 2010-10-04 08:24:26.34

View Complete Post


More Related Resource Links

SSIS error DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

  

I am having an issue when running an SSIS package directly on a SQL server.  The package moves data from tables on a SQL server 2005 inside our network out into a sql server 2005 in our DMZ.  Ultimately I'd like to run this from a scheduled job on the server....

The error that I am receiving is as follows:

Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "ABC" failed with error code 0xC0202009. 

I originally thought that this may be due to the credentials required for one of the connections not being passed correctly.  For this reason, I changed the encryption level of the SSIS package to be EncryptAllWithPassword.  I then ran the package in BIDS successfully.  I then connected to the server through SSMS on my machine (using my own windows account), and imported the package into the MSDB, supplying the password.  I then ran the package on my machine through SSMS successfully.  However when I opened a remote desktop session to the server itself (again, using my windows account) and ran the package through SSMS, I received the error above.  A colleauge has also run the package successfully through SSMS on his machine, but also received the same error when opening an R

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

  

When I execute a DTSX (which was developed in BIDS 2005) in through

command prompt (on a server which only has SQL Server 2005 and SSIS 2005) using dtexec.exe against /File paramger, it was working perfectly fine.

However, I get the following error message after executing on a server which has SQL Server 2005 and SSIS 2005 & 2008.  Is it possible to execute a DTSX, which was developed in BIDS 2005, on a server that has both SSIS 2005 & 2008?  Please advise.  I often get the following error message in such case.  Thanks!


Command:

    "c:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtexec" /FILE \\server123\DATA\AMP.dtsx /DECRYPT PassWordd > \\server123\DATA\output.txt


Error MSG:

     Microsoft (R) SQL Server Execute Package Utility
Version 9.00.4035.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started:  8:40:30 PM
Error: 2010-09-26 20:40:30.84
   Code: 0xC0011007
   Source: {0C157B60-C291-43ED-84A9-23F0DC7D5862}
   Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted.
End Error
Error: 2010-09-26 20:40:30.84
 &nbs

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method ca

  

I have a package that connects to IBM DB2 and imports data and saves it into text files.There are around 200 txt files. am using IBM OLEDB provider for DB2. After importing data into some text files like may be 50 or 70 or 100 or 170 , my package fails with error

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager  failed with error code 0xC0202009.

help needed plz...


ERROR 0x80004005 : DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER - Remote Execution of DTEXEC

  

Hello all.. 

 

I have a simple DTSX package that takes a CSV file and loads it into a table in SQL Server 2008 Ent. x64 bit (on 2008 Ent. Server).  The package runs well when DTEXEC is executed locally on the server which it resides on.  I run into trouble when I try to execute the package using PSExec like so:

C:\>c:\pstools\psexec \\myservr -u "mydom\myuser" -p "mypass" dtexec /FILE "X:\ETL\packages\test1.dtsx" /CHECKPOINTING OFF  /REPORTING EW /DECRYPT mykey

 

The package encryption is set to "EncryptAllWithPassword", which I supply along with DTEXEC "/decrypt" attribute.  The error I am getting is "SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "MyDB" failed with error code 0x80004005. There may be error messages posted before this with more information on why the AcquireConnection method call failed."

 

When the package is executed locally, the user connection properties are exactly the same (Windows Authenticated connection, using an administrative account).  The account specified in the SSIS log below (mydom\myuser - modifi

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend