The main situation I faced is my project references SSIS package Microsoft.SQLServer.ManagedDTS.dll, in VS2010 compile as .Net 3.5.
I have both SqlServer 2005 and 2008 on the same machine.
Here are the article analysising the reason and provide the complete solution: http://blogs.msdn.com/b/jason_howell/archive/2010/08/18/visual-studio-2010-solution-build-process-give-a-warning-about-indirect-dependency-on-the-net-framework-assembly-due-to-ssis-references.aspx
But a big problem is that I cannot find the file in machines with SqlServer 2008 in the path
C:\Program Files\Microsoft SQL Server\100\DTS\Binn\
Finally I found a way to get the file, I have uploaded it here
Microsoft.SQLServer.msxml6_interop.dll.zip (69.98 kb)
and if you cannot download it, to get the file in the following way as well:
- Find a machine installed SqlServer 2008 without SqlServer 2005
- Open cmd window
- Find the assembly folder dir /s C:\Windows\assembly\*Microsoft.SqlServer.msxml6_interop.dll
- Go into the folder and copy the file out copy ***\ Microsoft.SqlServer.msxml6_interop.dll c:
- Get the file from c:\
Now you get the file.
And the easiest way to solve the issue is rename the previous file: C:\Program Files\Microsoft SQL Server\90\DTS\Binn\Microsoft.SQLServer.msxml6_interop.dll to Microsoft.SQLServer.msxml6_interop.dll.bak. and then copy the new file here.
If this haven't solve the problem, some more references here:
http://connect.microsoft.com/VisualStudio/feedback/details/551532/cannot-build-project-in-2010-when-project-has-reference-to-ssis-2008-dlls-sqltask-manageddts-etc
http://www.8bit.rs/blog/2011/05/visual-studio-2010-cannot-reference-manageddts-dll-from-sql-server-2005/
-
a308fe64-8a6f-4392-9015-1ed9d25bc057|0|.0
写程序