SSIS with Azure features will not work in VS on another machine

Chris Hartmann 1 Reputation point
2021-04-22T19:11:46.133+00:00

I have an SSIS project that I developed in VS 2017 and I am moving to a new development workstation.

I have installed SsisAzureFeaturePack_2017_x86 on the new workstation

On the new workstation when I open VS 2017 and create a new SSIS project the Azure functions are available in the toolbox, however when I open my existing project created on my other machine the Azure functions are greyed out, and the package fails

Error message:

TITLE: Microsoft Visual Studio


The task with the name "dealer_com" and the creation name "SSIS.ReplacementTask" is not registered for use on this computer.
Contact Information:
Azure Blob Download Task; (C) Microsoft Corporation; All Rights Reserved


BUTTONS:

OK


SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,704 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 26,586 Reputation points
    2021-04-22T19:17:11.89+00:00

    Hi @Chris Hartmann ,

    I have installed SsisAzureFeaturePack_2017_x86 on the new workstation

    It seems that your previous machine has a different version of that Azure pack.
    Please make sure it is the same version like before.

    0 comments No comments

  2. Monalv-MSFT 5,926 Reputation points
    2021-04-23T01:47:30.567+00:00

    Hi @Chris Hartmann ,

    The download pages also include information about prerequisites. Make sure you install SQL Server before you install the Azure Feature Pack on a server, or the components in the Feature Pack may not be available when you deploy packages to the SSIS Catalog database, SSISDB, on the server.

    May I know if you download SQL Server and Azure Feature Pack for Integration Services (SSIS) on your other machine?

    If not, please download them.

    Best regards,
    Mona


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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.