Public preview of SSIS Projects for VS 2022

[Chunhua]

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.

[heta77]

Only Sql 2019 or Sql 2022

[Pjtaylor]

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
---------------------------

[Vinod Jacob]

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

[Robin Wilson]

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.

[Robert Praetorius]

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)

[jpaszto]

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

[LanceAtWork]

FINALLY! Now I can wait for the bugs to be worked out :)

[WendyYe]

Method not found: 'SqlWorkbench.Interfaces.IAzureCloudConfiguration' 
It solved in VS2022 17.5 preview 2. You can install SSIS in this VS version.
@jpaszto @Pjtaylor 

[MarkNoble]

I'm also wondering where to report bugs, along with @Robert Praetorius .

In my case I was following an MS Learn tutorial and encountered an issue with toggling checkboxes in Logging.  Details of the issue can be found here:

https://hyp.is/zilNgH1QEe24cMvs0dqMkA/learn.microsoft.com/en-us/sql/integration-services/lesson-3-2-...

[jpaszto]

@WendyYe 
The error message "Method not found: 'SqlWorkbench.Interfaces.IAzureCloudConfiguration'" no longer appears in VS2022 Version 17.5.0 Preview 2.0 .  But the SQL connection does not work within the "SQL Server Database Project". When trying to connect, the SQL connection selection/setup manager is not displayed. Instead, the connection attempt ends with a "Login failed for user" error.

[Chunhua]

Thank you everyone for comments and feedbacks. If you experience any issue or would like to share your feedback, would you help report in SSIS extension in marketplace Q&A tab?   

[WendyYe]

Hi, @jpaszto 
Could you please provide the repro steps with screenshot etc, which would help us in finding the root cause. 

[FEI-ER]

I posted this on the Q&A tab as well:

VSIXBOOTSTRAPPER.EXE that gets executed as part of the install contains a digital signature that leads to an untrusted root CA, which is causing the file to be marked as untrusted.

Can you please update the digital signature on that file to use a valid certificate?

Thank you.

[mrk404]

HI,

sins there is no standalone installation file for SSIS Projects for VS 2022 is it possible to install it using a workload component ID  when creating an offline installation ?

I'm using this guide to do it ,and this is the CMD responsable for that :

c:\localVSlayout\vs_enterprise.exe --noweb --add Microsoft.VisualStudio.Workload.ManagedDesktop --add Microsoft.VisualStudio.Workload.NetWeb --includeOptional

So as I understand I need to add another ID with the --add flag which will be responsible for downloading the SSIS extension!

so please if there is any solution for that let me know and thanks everyone

[robza]

For offline installation I download the most recent version from the marketplace and install it using MDT / CMD-task like this:

start "" /wait cmd.exe /c Microsoft.DataTools.IntegrationServices.exe /INSTALLALL /passive /norestart /log c:\vs2022_ssis.log

[mrk404]

@robza  thanx for your replay , i did use the CMD you provided but the installation was not quiet and not passive !

i still get this prompt assking me to click install !!! :

i also used this CMD :

Microsoft.DataTools.IntegrationServices.exe /INSTALLALL /passive /norestart /log c:\vs2022_ssis.log

Microsoft.DataTools.IntegrationServices.exe /INSTALLALL /quiet /norestart /log c:\vs2022_ssis.log

do you have any ideas please ?

[robza]

The installer has to be fixed. The 2019 version is working for me. Version 0.1 was working either (with "/quiet").

See also the discussion at the Q&A:

[mrk404]

@robza Now I see, thanks brother :), I guess I will wait for the next update (0.3)

[currcmpsvc]

I'm unable to perform an offline installation of the SSIS package.  I have a Powershell script using the /quiet option which installs the first portion of the application but then it launches the VSIX installer which requires manual intervention.  Is there a setting I can use that will allow the whole process to have no  UI and no prompts?

[MarkNoble]

In Step 12 of this MS Learn Tutorial, the checkboxes were un-checkable in VS 2022.

https://hyp.is/6v5uyKvuEe2GyRPS8P2Z9w/learn.microsoft.com/en-us/sql/integration-services/lesson-5-2-...

It's under Package Configuration Wizard > Select Properties to Export under Objects.

Navigating through the tree with the arrow keys exposed checkboxes that weren't initially visible, but I was unable to interact with them by selecting them with the mouse or toggling them with the space bar as I'd expect.

EDIT: This issue seems to have been resolved in version 0.3 that was apparently released the day after I posted this.

[ChristopherFitzy]

Has anybody been able to successfully deploy this extension with SCCM/MECM? I can script the installation if running under the User account, but as soon as I try using the SYSTEM user context (which is what SCCM uses), the installation just hangs. I have tried several variations of this install command line:

Microsoft.DataTools.IntegrationServices.exe /install:449d362a /quiet /norestart

[MarkNoble]

It'd be nice to see SSIS get a SFTP task that isn't a 3rd party add-on.

Looks like most folks are accomplishing this with an Execute Process Task, but it'd be nice if SSIS were modernized with this common task type - maybe by extending and enhancing the FTP Task type to support SFTP as well.

[Robin Wilson]

Yes it would as these tools go through many iterations over the years yet none of the main fundamental limitations reported each time are ever addressed.

In SSIS this includes an inability to connect to any sort of secure FTP, inability to connect to files on SharePoint (there was a workaround involving the open in Explorer option that only worked in IE mode which is now blocked), inability to authenticate to secure email systems, inability to correctly interpret Microsoft Excel files or CSV files where columns are set with an incorrect length or format, inability to import the SQL Server report catalogue in the correct version if not the latest so all code disappears.

So it seems all we get, a year after release of each VS version when the previous one has already been de-supported is the ability to access the same old features in the new supported version of VS. So it always feels like an afterthought.

For the FTP tasks I normally use WinSCP controlled with a batch file that is executed from SSIS to send or receive a file.

[alariosacevedo]

testing...

[greenersw]

Has a release date for the RTM version been announced yet?

[Harpreet-Singh]

GA Version was released on June 5th, 2023.

https://marketplace.visualstudio.com/items itemName=SSIS.MicrosoftDataToolsIntegrationServices

Version 1.0

• Release Date: Jun 5, 2023
• Build Version: 16.0.5223.0
• Tested against Visual Studio 2022 17.6
• General Availability (GA) release