none
SSDT 2015 - SSIS Toolbox - 'Azure' is greyed out RRS feed

  • Question

  • I have installed SSDT from the download-sql-server-data-tools-ssdt

    I have also installed SSIS Feature Pack for Azure for SQL Server 2016

    Also, clicked on 'Azure' in the Toolbox, then clicked on 'Download Azure Feature Pack'...installed the vs_community.exe, and selected everything.

    But, when I open SSDT 2015, and create a new SSIS project...In the SSIS Toolbox, 'Azure' is greyed out.

    How do I get this to work?

    Wednesday, May 17, 2017 7:56 PM

Answers

All replies

  • Hi JayLo37209,

    Since the issue is more related to SSDT itself, I’m moving this thread to SSDT forum for better response.

    Thank you for your understanding and support.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, May 18, 2017 8:59 AM
  • Anyone else having this issue?
    Wednesday, May 24, 2017 12:45 PM
  • Hi JayLo37209,

    Which version of Azure feature Pack do you install?

    You can try these two solutions.

    #1 Switch TargetServerVersion to SQL Server 2016.

    #2 Keep TargetServerVersion to SQL Server vNext(2017), download and install Microsoft SQL Server vNext Integration Services Feature Pack for Azure.

    The download site is https://www.microsoft.com/en-us/download/details.aspx?id=54798.

    If they still don't work, please let me know.

    Thanks,

    Ran


    Thursday, May 25, 2017 9:01 AM
  • Switch TargetServerVersion  to SQL Server 2016 worked.  Thanks much.
    • Marked as answer by JayLo37209 Thursday, May 25, 2017 12:41 PM
    Thursday, May 25, 2017 12:41 PM
  • Hi JayLo37209,

    Which version of Azure feature Pack do you install?

    You can try these two solutions.

    #1 Switch TargetServerVersion to SQL Server 2016.

    #2 Keep TargetServerVersion to SQL Server vNext(2017), download and install Microsoft SQL Server vNext Integration Services Feature Pack for Azure.

    The download site is https://www.microsoft.com/en-us/download/details.aspx?id=54798.

    If they still don't work, please let me know.

    Thanks,

    Ran


    I downloaded and installed the feature pack and changed the Version to 2017 and there is a Project property called Azure Enabled and I set this to True.

    Thanks Shiven:) If Answer is Helpful, Please Vote

    Thursday, November 14, 2019 6:12 AM