Using 2008 Bids (VS2008) for SSIS Packages, Installed a SS2K14 Dev Edition for SSMS.
After SS2K14 Dev install' SSIS 2008 Script tasks no longer reference Microsoft.SQLServer.ManagedDTS
I've added the reference and resolved errors and warning in the script task. But close the script task editor and save, the reference does not stick. Open the script editor and the reference is missing.
Everything was going well until I installed SQL Server 2014 Dev Edition side by side.
Will uninstalling SS2K14 Developer Edition return to previous state?
How do I resolve the Missing Reference so that its permanent (sticks)?
Thank you for any assistance - Covi
Warning 12 The referenced component 'Microsoft.SqlServer.ManagedDTS' could not be found.
Replacing the Microsoft.SqlServer.Msxml6_interop.dll in the GAC with the one from SQL2008 solved it for me. Make sure to follow the instructions in the link below. I was able to build my project in VS2010 and I checked that I was still able to run SSIS packages
on my machine and that the application would run on a machine that has not been patched with the 2008 Microsoft.SqlServer.Msxml6_interop.dll.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.