SSIS Package Fails

• sudhirnune

  SSCrazy

  Points: 2342

  More actions

  September 11, 2012 at 3:13 am

  #393153

  Hi All,

  The SSIS Package Fails saying

  "The AcquireConnection method call to the connection manager "Excel_Source" failed with error code 0xC0202009"

  Here is how the Package is Ran:

  1. Package has triggered as part of SQL Server Job.

  2. SQL Server Job Ran based on proxy, an user will be able to Access only if he access to the proxy.

  3. SQL Server has been set to Run on 32 Bit Run Time.

  4. When the Excel file size is less than or equal to 2MB, File gets loaded with no issues.

  In my local machine the %TMP% is free and C Drive has good Space update 2 GB.

  Please need help to understand where the issue is.

• Rajeshpalo

  Mr or Mrs. 500

  Points: 567

  More actions

  September 11, 2012 at 11:05 pm

  #1536560

  Hi,

  check "Run64BitRuntime" property , it is TRUE or FALSE?make it FALSE.

  Cheer's
  Rajesh

• Chris Hurlbut

  SSCarpal Tunnel

  Points: 4162

  More actions

  September 13, 2012 at 2:18 pm

  #1537474

  Here is an excellent article from 2008:

  http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/64585/

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  September 13, 2012 at 2:19 pm

  #1537475

  churlbut (9/13/2012)

  ---

  Here is an excellent article from 2008:

  http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/64585/

  Shall we make this easier for others?

  http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/64585/