This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 18%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
I've developed a SSIS package uploads data to a Azure Blob Storage container. The SSIS package uses the Azure Blob Upload task which is available from the Azure Features Pack which I installed prior to the development. The SSIS package works perfectly well when executed from designer using Microsoft SQL Server Data Tools for Visual Studio (SSDT). Following usual practice I then built the deployment files and deployed the SSIS project this package was part of to our Development Integration server. However, after creating a SQL Agent job to run the new SSIS package and executing the said SQL Agent job the job failed to execute indicating the Azure Blob Upload tasks failed to load. After a bit of Googling I understand that I need to enhance the SQL Server I've deployed the SSIS package to use Azure components. That's where I need your help.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 10%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Bleay, Michael (IT Services), just checking in to see if the below-answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Hi @Bleay, Michael (IT Services), It is not enough to deploy just your Visual Studio SSIS Project to the SSIS run-time server. You need to install the "Azure Feature Pack for Integration Services (SSIS)" on that SSIS run-time server too.
I knew about the Azure feature pack before I posted my question. What I was hoping for was not reaffirming my diagnosis but more how do I go about adding the Azure feature pack to the runtime server. In the end I got a busy DBA to add the Azure feature pack and once he did the SSIS package then worked like a dream.