The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009 on MS Visual Studio 2012

• weihelen

  SSC Veteran

  Points: 246

  More actions

  February 16, 2015 at 12:32 pm

  #314595

  Hi, SSIS Expert,

  i'm having an issue with a package Execution on MS Visual Studio 2012.

  I have a simple SSIS package. the source is Excel source with extension .xlsx on my PC, c: driver.

  Database is on an intranet SQL server 2012 .

  All data convertion debugges has been done , however, the last Exceution Result shows three main errors:

  1. [Excel Source [1028]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.

  The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.

  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

  2. [SSIS.Pipeline] Error: Excel Source failed validation and returned error code 0xC020801C.

  and 3. [SSIS.Pipeline] Error: One or more component failed validation.

  Anyhow, would you please give me a hint to resolve this Execute error issue?

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  February 17, 2015 at 1:27 am

  #1777968

  Please do not crosspost. It wastes peoples time and fragment replies.

  Original thread with replies can be found here:

  http://www.sqlservercentral.com/Forums/Topic1660788-2799-1.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP