question

ChrisHartmann-9958 avatar image
0 Votes"
ChrisHartmann-9958 asked Monalv-msft commented

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

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered

Hi @ChrisHartmann-9958,

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft commented

Hi @ChrisHartmann-9958 ,

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.




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ChrisHartmann-9958,

May I know if you have anything to update?

Best regards,
Mona

0 Votes 0 ·