"Invalid class string" when trying to "save copy package"

Randy S 36 Reputation points
2022-10-28T17:50:18.94+00:00

I just set up Visual Studio 2019 with the Integration Services extension installed. I've opened an existing .sln and it is set to "Package deployment model". When I do a "file--save copy of" to save my package and I select SQL Server as the destination, no matter what I do I get an "invalid class string". I can try to target my local SQL or one of the servers. Both are SQL2019. I put in "SQL Server" as the destination, the server name, and if I try to save I get the error. I even get it if I hit the "..." on "Package path" prompt, so it can't even connect to get a list of packages.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,522 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 35,381 Reputation points
    2022-10-31T08:37:43.743+00:00

    Hi @Randy S .

    Could you please create a simple SSIS project and then try to save the copy package to see if the error will disappear?

    If the error still occurs, try to repair Visual Studio.

    Someone also mentioned that the issue has been resolved after installing SSMS18.x version.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments