SSIS upload task not working when run under SQL Server agent

Manas Dasgupta 6 Reputation points
2020-07-27T14:04:07.84+00:00

I get the following error when I run the package under SQL Server agent:

Task Azure Blob Upload Task Description: Upload task has stopped with exception: Unable to create Azure Blob container. Endpoint: https://xxxxxxxxx.blob.core.windows.net/, Container Name: xxxxxx. End Error DTExec: The package execution returned DTSER_SUCCESS (0).

But the same package works fine when run under Visual Studio SSDT.

Any pointers?

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,447 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,795 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,621 Reputation points
    2020-07-27T14:14:22.2+00:00

    When you run the package from VS, it should be taking your credentials to connect to Blob storage I believe. But when the job is run using Agent job, it takes SQL server account credentials.

    Try creating proxy with your own credentials and use this proxy to run agent job.

    129293-configure-an-ssis-package-to-execute-as-a-proxy-account

    Also it's better to reach out in dedicated forum for SSIS questions

    Post SSIS question

    ===============================================
    If the response helped, do "Accept Answer" and upvote it -- Vaibhav

    0 comments