When I compile my C# code, the compiler flags the following using statement with a compiler error:

using DTS = Microsoft.SqlServer.DTSPkg80;

This is the compiler error message I get:

The type or namespace name 'SqlServer' does not exist in the class or namespace 'Microsoft' (are you missing an assembly reference?)

Does anyone have an idea what the problem might be here?

Did you add a reference to Microsoft.SqlServer to your project? If not, right-click the project in Solution Explorer and select Add Reference. Find Microsoft.SqlServer.dll, select it, and click Add. This is off the top of my head, so it might very a little.

HTH,
Ryan

Hi Ryan,

No such DLL exists on my hard drive "microsoft.sqlserver.dll"

I have SQL server 2000 and 2005 on my PC, but no such dll named    microsoft.sqlserver.dll

Are you sure this is the correct dll to reference?

Bill

Sorry about that. I believe that the actual file you are looking for is C:\Program Files\Microsoft SQL Server\80\Tools\Binn\DTSPkg.dll.

Let me know if that helps.

Ryan

hey am also facing same pblm...i couldn't find in my project also...i followed same steps...adding system.web.dll..

i can't see tht assembly..why???

Hi, wish I could help you. It was a long time ago that I asked that problem, and I don't know how I got it resolved?