How Profiles will work on SQL Serve 2022 and SSIS created on VS2019?

[Moisey Gruzman]

Our IT expects to upgrade Profiles Environment to newest SQL Server and VS. How Profiles will work in that Environment or other new Server and VS? We need this know before they will start upgrade.

[Brown, Nicholas William]

Moisey

 

We have not tested profiles on SQL Server 2022 yet, however, I don’t foresee any issues with the database. We are not using any of the features depreciated by SQL 2022.

 

SSIS 2022 claims not to have any depreciated features, so again, the SSIS package should work, but will almost certainly have to be recompiled in the latest version of Visual Studio. This can be an issue depending on the version. SSIS 2016 for example was very particular about the version of Visual Studio it was compiled on.

 

I will attempt to perform an install on SQL Server 2022 in the near future to confirm compatibility.

 

Nick

--
You received this message because you are subscribed to the Google Groups "ProfilesRNS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to profilesrns...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/profilesrns/5ba512aa-2c3f-4cb1-8b5b-9d29e043e248n%40googlegroups.com.