李国宝

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:

1. Find a machine installed SqlServer 2008 without SqlServer 2005
2. Open cmd window
3. Find the assembly folder  dir /s C:\Windows\assembly\*Microsoft.SqlServer.msxml6_interop.dll
4. Go into the folder and copy the file out copy ***\ Microsoft.SqlServer.msxml6_interop.dll c:
5. 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/

写程序