Attempting to connect to SQL Server in VS SSDT to edit DTSX / SSIS process, "Invalid Class String"

KSCHRAM 1 Reputation point
2021-10-27T17:22:29.153+00:00

I'm attempting to edit an existing .dtsx file (SSIS package).

I've got Visual Studio 2019 and the SQL Server Integration Services Project extension installed.

I create a new Integration Services Project, create a Connection to my SQL Server, then because I'm trying to edit existing SSIS packages, I want to import the current ones from SQL Server. So I go to "SSIS Packages" in the Solution Explorer, right click, Add Existing Package.

Change "Package Location" to SQL Server, leave Windows Authentication on, then I go to navigate to the file location and I get an error message saying simply "Invalid Class String"

When I go to more details, I get the following: 

Invalid class string


------------------------------
Program Location:

   at Microsoft.SqlServer.Dts.Runtime.Application.GetPackageInfos(String strFolder, String serverName, String serverUserName, String serverPassword)
   at Microsoft.DataTransformationServices.Controls.ServerPackagesForm.<>c__DisplayClass14_0.<CreateSqlServerEnumerationForm>b__0(String path)
   at Microsoft.DataTransformationServices.Controls.ServerPackagesForm.CreateForm(PackageInfosGetter packageEnumerator, String serverName, Boolean openExisting, String defaultName)
   at Microsoft.DataTransformationServices.Controls.ServerPackagesForm.CreateSqlServerEnumerationForm(String serverName, String user, String pwd, Boolean openExisting, String defaultName)
   at Microsoft.DataTransformationServices.Controls.PackageLocationControl.buttonBrowse_Click(Object sender, EventArgs e)

===================================

Invalid class string


------------------------------
Program Location:

   at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetPackageInfos(String bstrPackageFolder, String bstrServerName, String bstrServerUserName, String bstrServerPassword)
   at Microsoft.SqlServer.Dts.Runtime.Application.GetPackageInfos(String strFolder, String serverName, String serverUserName, String serverPassword)

Anybody know what the issue is?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,676 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,581 Reputation points
    2021-10-28T05:44:45.76+00:00

    Hi @KSCHRAM ,

    I test locally that I could not re-produce the issue.

    Could you please help try to import the package to local and then add the package from file system to see if it will work or not?

    Please help check the version of SSMS, someone mentioned in VS community that the issue went away after installing SQL Server Management Studio v18+.

    Note that my SSMS is v18, you may have a check of your SSMS version to see if it could resolve the issue.

    Unable to Copy existing Server Side SSIS package into SSIS Project

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October