Share via

SSMS Job Agent execute SSIS package and unable to find file on Azure Storage

Ing. Miroslav Nekoranec 26 Reputation points
2022-11-03T13:47:37.38+00:00

Hi,

I have SSIS Package, which Copy data from parquet file in Azure Data Lake Storage Gen2 (I am signed by AccessKey into Data Lake Storage Gen2) to local SQL server database.

When I execute Package Via Integration Services Catalogs (in SSMS) everything goes well.

But when I create Job in SQL Server Agent to execute this package, execution failed. In report of this execution I see problem, that file on storage is not accessable (file not found)...

Any idea? Thank you

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,426 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 35,556 Reputation points
    2022-11-04T01:47:24+00:00

    Hi @Ing. Miroslav Nekoranec ，

    It seems that the account to run the sql agent job do not have full permission to the file.

    You may use a proxy account to run the job.

    create-a-sql-server-agent-proxy
    running-a-ssis-package-from-sql-server-agent-using-a-proxy-account

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest