Excel source getting error

• ranganathanmca

  SSC Eights!

  Points: 920

  More actions

  March 24, 2011 at 8:43 am

  #234529

  Hi Guys.,

  we are using Excel source getting 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.

  Please help me out to reslove this error

  Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  March 25, 2011 at 3:10 am

  #1303428

  Is that the only error? (as it mentions "There may be error messages posted before this ").

  Does the Excel file exists when the package starts running? Are you running the package in 32-bit?

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