Link to home
Start Free TrialLog in
Avatar of yonbret
yonbretFlag for United States of America

asked on

SSIS Job Won't Run with SQL Agent

I have created a SSIS job to transfer data from an Excel Spreadsheet to a SQL Server 2012 table.

When I run the package in Visual Studio, everything executes without a problem.

When I try running the job in SQL Server using SQL Agent, I get an error message to check the error Log. Nothing appears in the error log.

When I try running the job from a command prompt, I see the error as follows: "DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager DailyLogExcel" failed with error code 0xC0209303.

I have already set “Run64BitRuntime” property to false.

Any suggestions?
Avatar of Randy Knight, MCM
Randy Knight, MCM
Flag of United States of America image

Does the SQL Server Agent Service Account have permissions to the Excel file?
Avatar of yonbret

ASKER

To rule out a permission error, I granted Modify permission to Everyone on the Excel spreadsheet.

Everyone should include the SQL Agent Account
Log on to the server console using the SQL Agent Account and see if it can access the file.  That will tell you for sure if the permissions are working or not.
ASKER CERTIFIED SOLUTION
Avatar of yonbret
yonbret
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of yonbret

ASKER

I had to call Microsoft for a resolution