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

Ing. Miroslav Nekoranec 26 Reputation points


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

    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.



    Zoe Hui

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

0 additional answers

Sort by: Most helpful