Blog Post

SQL Server Integration Services (SSIS) Blog
1 MIN READ

General availability of SSIS Projects for VS 2022

Chunhua's avatar
Chunhua
Icon for Microsoft rankMicrosoft
Jun 20, 2023

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

 

You can get the latest download from SQL Server Integration Services Projects 2022 - Visual Studio Marketplace and visit documentation page for known issues, 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 Jun 20, 2023
Version 2.0

15 Comments

Show More
  • EAjeroh's avatar
    EAjeroh
    Copper Contributor
    Jul 11, 2023

    Hello: 

     

    I have successfully installed Visual Studio 2022, and I have downloaded version 4.4 of the "SQL Server Integration Services Projects" extension.  But when I go to run the .exe install, I get the following prompt:  "Install this product to the selected Visual Studio Instance(s):" - but my installed instance does not show up for me to select.  Any ideas? 

     

    I have already run a repair of my Visual Studio instance installation, and this took 2-3 hours to complete - and my instance still doesn't show up in the SSIS Projects extensions installation process.

     

    Any ideas?  Thanks for your assistance

  • Vinod Jacob's avatar
    Vinod Jacob
    Brass Contributor
    Jul 11, 2023

    I keep getting the following error and some of the normal SSIS Tasks are missing from the SSIS Toolbox

    Severity Code Description Project File Line Suppression State
    Error Error loading NWHEDBICC.dtsx: Cannot create a task from XML for task "Upload File to GoAnywhere", type "Microsoft.ScriptTask" due to error 0x8013141A "". C:\Users\vjacob1\source\Workspaces\NWPhelps\Data Extracts\ED BICC Extract\NWHEDBICC.dtsx 1
    Error Error loading NWHEDBICC.dtsx: Cannot create a task from XML for task "Truncate ED BICC Tables in SHN Database", type "Microsoft.ExecuteSQLTask" due to error 0x8013141A "". C:\Users\vjacob1\source\Workspaces\NWPhelps\Data Extracts\ED BICC Extract\NWHEDBICC.dtsx 1
    Error Error loading NWHEDBICC.dtsx: Cannot create a task from XML for task "Execute ED BICC Stored Procedure", type "Microsoft.ExecuteSQLTask" due to error 0x8013141A "". C:\Users\vjacob1\source\Workspaces\NWPhelps\Data Extracts\ED BICC Extract\NWHEDBICC.dtsx 1
    Error Error loading NWHEDBICC.dtsx: Cannot create a task from XML for task "Archive Flat File", type "Microsoft.FileSystemTask" due to error 0x8013141A "". C:\Users\vjacob1\source\Workspaces\NWPhelps\Data Extracts\ED BICC Extract\NWHEDBICC.dtsx 1

     

    When I check my SSIS Toolbox - these tasks do not exist.

    I tried reinstalling the latest version of SSDT and it does not fix the issue.

    I also tried repairing and reinstalling the Visual Studio 2022 - what can I do to resolve the issue I cannot operate on any package.