Type or namespace name 'Runtime' does not exist in the namespace 'Microsoft.SqlServer.Dts'

Question

Type or namespace name 'Runtime' does not exist in the namespace 'Microsoft.SqlServer.Dts'

daniness

SSCrazy

Points: 2890
More actions
February 1, 2018 at 11:51 am

#410168

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.
Could anyone please advise on the fix for this error? Thanks in advance!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

x SSC-Insane Points: 23660 More actions · Answer 1

wild guess:

[url]https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1b3ed694-cf02-445e-8ff4-0de4fd45a464/error-dts-does-not-exist-in-the-namespace-microsoftsqlserver?forum=sqlintegrationservices[/url]

this one talks about that "runtime" is in the namespace "Microsoft.SqlServer.ManagedDTS", could it be possible that this is the reference you need to add?

daniness SSCrazy Points: 2890 More actions · Answer 2

Thanks, Patrick....but I've tried adding the reference, "Microsoft.SqlServer.ManagedDTS" and I'm receiving a "The type or namespace name 'ManagedDTS' does not exist in the namespace 'Microsoft.SqlServer' (are you missing an assembly reference?)" error, in addition to the original Runtime error...any other suggestions are welcome....Thank you!

x SSC-Insane Points: 23660 More actions · Answer 3

oh well, sorry for the erroneous guess! I was googling your error and honestly the results look like a real mess LOL

you could try posting in the integration services subject here, its included in the "data warehousing" group on this website. it doesn't look like its as busy as it could be but maybe some ssis'ers spend time there. also found your question on stack exchange too so at least your asking in plenty of places 🙂

daniness SSCrazy Points: 2890 More actions · Answer 4

Thanks, Patrick. I've posted my question on the integration services forum...I'm hoping I get some suggestions there.