CODEWITHSUNDEEP
visual-studiossis
FlyingFree
FlyingFree

Reputation: 21

Exception deserializing the package error when executing SSIS package

I've just installed Visual studio Professional 2015 on a Microsoft 2019 Server with the following tools:

When I go to run an SSIS package that works on other machines I get the following error message:

TITLE: Microsoft Visual Studio
------------------------------

Exception deserializing the package "The type initializer for 'Microsoft.SqlServer.Dts.Runtime.XMLSerializationHelper' threw an exception.".

------------------------------
ADDITIONAL INFORMATION:

The type initializer for 'Microsoft.SqlServer.Dts.Runtime.XMLSerializationHelper' threw an exception. (Microsoft.SqlServer.ManagedDTS)

------------------------------

Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.STrace, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.ManagedDTS)

------------------------------

Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.STrace, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

I've repaired SQL Server Data tools and Visual studio itself with no luck. Any suggestions?

Upvotes: 1

Views: 9115

Answers (1)

Ajeet Verma
Ajeet Verma

Reputation: 1123

I had created a new SSIS project and facing same problem while executing it. Generally this type of issue occurred when you have not selected the right SQL Server Version. You have to first check the SQL Server version installed in your or remote machine and verify it with the SSIS Project. You have choose the same SQL Server version in Visual studio for your SSIS project.

SSIS Project>>Right Click (properties)>>Configuration Properties>>General>>Target Server Version

After setting this if still you are facing the same issue then please check the below settings.

SSIS Project>>Right Click (properties)>>Common Properties>>project>>Security>>Select the appropriate protection level.

Solution-1 enter image description here

enter image description here

Solution-2

enter image description here

Upvotes: 4

Related Questions