Blog Post

SQL Server Integration Services (SSIS) Blog
1 MIN READ

Public preview of SSIS Projects for VS 2022

Chunhua's avatar
Chunhua
Icon for Microsoft rankMicrosoft
Nov 25, 2022

We’re happy to announce the popular and long-awaited SQL Server Integration Services Projects extension is now available for Visual Studio 2022!

 

You can get latest download from SQL Server Integration Services Projects 2022 - Visual Studio Marketplace, and visit documentation page for installation and troubleshooting guidance. 

If you experience any issue or would like to share your feedback, please visit SSIS extension in marketplace Q&A tab.

 

 

 

 

Updated Dec 12, 2022
Version 2.0

26 Comments

  • jpaszto's avatar
    jpaszto
    Copper Contributor

    After installing the extension, I can't connect to local SQL.
    Otherwise I have the same problem as Pjtaylor.

  • Installed SSIS Projects 0.2 for 2022 with VS 2022 17.4.2 and saw many crashes.  Where should I report them?  Should they go to VisualStudioLand or SSISLand?

     

    (I understand this is a preview.  I'm not that disappointed by the crashes - better in the preview than the released product.  And I have VS 2019 with SSIS Projects 4.3 to fall back on so it's not critical)

  • robinwilson16's avatar
    robinwilson16
    Brass Contributor

    Pjtaylor could your issue be due to the fact your SSIS projects are Azure-enabled which I am guessing they may be from your error:

    Method not found: 'SqlWorkbench.Interfaces.IAzureCloudConfiguration

    It says this as point 7:

    Azure-enabled SSIS projects are not supported

    Can you disable the Azure features, assuming you don't need them.

  • Vinod Jacob's avatar
    Vinod Jacob
    Brass Contributor

    Some preview version - only for the latest SQL Versions, I guess will be waiting till the general release.

  • Pjtaylor's avatar
    Pjtaylor
    Copper Contributor

    Seems to break SQL projects for me. When I try to go into a SQL object, I get:

    ---------------------------
    Microsoft Visual Studio
    ---------------------------
    Method not found: 'SqlWorkbench.Interfaces.IAzureCloudConfiguration Microsoft.SqlServer.Management.UserSettings.AzureCloud.GetAzureCloudConfiguration(System.String, Boolean)'.
    ---------------------------
    OK
    ---------------------------