question

KSCHRAM-5478 avatar image
0 Votes"
KSCHRAM-5478 asked YitzhakKhabinsky-0887 edited

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

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-generalsql-server-integration-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@KSCHRAM-5478,

Please clarify that you need to "...I want to import the current ones from SQL Server..." run-time server environment in SSIS Catalog and use SSIS packages/project in you dev. environment on your personal machine in VS2019?

0 Votes 0 ·

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @KSCHRAM-5478,

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




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @KSCHRAM-5478,
Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

0 Votes 0 ·