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!