September 11, 2012 at 6:36 pm
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.
September 11, 2012 at 7:22 pm
Does the sql server agent service account have permissions to the folder where the excel file resides?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 11, 2012 at 8:31 pm
Have you tried running the package outside of SQL Server? If so, what are the results?
September 11, 2012 at 11:22 pm
Yes all the needed Access are available.
September 12, 2012 at 5:07 pm
Does the package run from within bids?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 12, 2012 at 6:59 pm
Yes it running Perfectly in all the places....! But Fails on one Server. that to when the File size is greater than 2 MB
September 12, 2012 at 8:37 pm
sudhirnune (9/12/2012)
Yes it running Perfectly in all the places....! But Fails on one Server. that to when the File size is greater than 2 MB
Running perfectly in all the places??
Is this package running on multiple servers? And by all places does that also mean that using the connections required for this one server, that the package runs perfectly from within BIDS (on that server if you must)?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply