How to fix sql server agent job failure while extracting data from a excel file and storing in a sql db using a ssis .dtsx package?

Deepak Kumar 5

I am getting following error when running ssis .dtsx package from sql server agent job. This package is extracting data from a excel file and storing in a sql DB. please find following error:

The step did not generate any output. The return value was unknown. The process exit code was -529697949. The step failed.

This job is run using a service account on sql DB.

When this package is run manually it is working fine. Please help me to solve this issue.

Erland Sommarskog 110.4K Reputation points MVP

2023-11-29T22:43:52.5833333+00:00

Is the Excel file on a local disk or on a file share?
Deepak Kumar 5 Reputation points

2023-11-29T22:47:40.5966667+00:00

It's on a file share on a network file system. I have tried to keep the file on local disk as well but with same results.

1 answer

ZoeHui-MSFT 36,116 Reputation points

2023-11-30T01:31:48.68+00:00

Hi @Deepak Kumar,

Usually, it will be a permission issue.

Make sure the account used to run the job has full permission to read the excel file.

You may also consider using proxy account to run the job.

Running a SSIS Package from SQL Server Agent Using a Proxy Account

If this does not work, you may follow the article to do generally troubleshoot.

SSIS package does not run when called from a SQL Server Agent job step

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.
Please sign in to rate this answer.
Deepak Kumar 5 Reputation points

2023-12-08T19:14:28.53+00:00

Hi Zoe,

Thank you for your response! I am using a proxy configured on sql server to run the job. Although this proxy user was imported from pervious sql version. Do you think creating a new proxy will be a possible solution to my problem.

I went through and have implemented recommendation from both the documents mentioned in your comment before coming to this forum.

Regards,

Deepak

Erland Sommarskog 110.4K Reputation points MVP

2023-12-08T22:24:18.4966667+00:00

Setting up a new proxy seems like a quick test to do.

Likhitha 0 Reputation points

2024-09-19T10:48:40.04+00:00

I am facing a similar issue where the package is running manually but through job agent it is failing. And the error is also.

The package is trying to extract data from Excel and load into SQL server table. It did working when I installed 2010 access database engine 64 bit. But it was end of life...so we have to 2016 access db engine..can someone please help me out
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to fix sql server agent job failure while extracting data from a excel file and storing in a sql db using a ssis .dtsx package?

1 answer

Your answer