Public preview of SSIS Projects for VS 2022

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

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.

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)

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:

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.

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

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

Only Sql 2019 or Sql 2022

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

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.