Home Forums Data Warehousing Integration Services Type or namespace name 'Runtime' does not exist in the namespace 'Microsoft.SqlServer.Dts' RE: Type or namespace name 'Runtime' does not exist in the namespace 'Microsoft.SqlServer.Dts'

  • daniness - Wednesday, February 14, 2018 12:07 PM

    Hi experts! So I'm running into the following error after adding connection managers to an ssis package: "The type or namespace name 'Runtime' does not exist in the namespace 'Microsoft.SqlServer.Dts' (are you missing an assembly reference?).

    I tried opening the script task, clicking on "Edit Script", right clicking on the project in Project Explorer, selecting "Properties" and changing the "Target Framework" to ".Net Framework 3.5", as I've seen suggested on some sites, but no go. I also tried to right click on the project in Project Explorer and selecting "Add Reference", but I don't see 'Microsoft.SqlServer.Dts.Runtime' listed under the .NET tab. I've also tried adding the reference, "Microsoft.SqlServer.ManagedDTS", to no avail. Furthermore, I've tried installing a newer Target Framework, and I received a message saying that I have .Net Framework 4.62, yet it doesn't show up in the Target Framework dropdown when I go to the Project's properties.

    Could anyone please advise on the fix for this error? Thanks in advance!

    Why would adding a connection manager have any effect on your script task? What does the script task do?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.