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,394 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,487 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 34,581 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