SSIS Package Fails

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » SSIS Package Fails

SSIS Package Fails

Rate Topic

Display Mode

Topic Options

Author

Message

sudhirnune

Posted Tuesday, September 11, 2012 3:13 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 11:23 AM
Points: 79, Visits: 185

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.

Post #1357221

rajeshpalo

Posted Tuesday, September 11, 2012 11:05 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, January 23, 2013 9:05 PM
Points: 16, Visits: 143

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

Cheer's
Rajesh

Post #1357787

churlbut

Posted Thursday, September 13, 2012 2:18 PM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 12:36 PM
Points: 975, Visits: 342

Here is an excellent article from 2008:
http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/64585/

Post #1358864

Lynn Pettis

Posted Thursday, September 13, 2012 2:19 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 9:31 PM
Points: 21,588, Visits: 27,381

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/

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1358865

« Prev Topic | Next Topic »

Permissions