Home All Groups Group Topic Archive Search About
Author
28 Mar 2007 1:10 AM
Chris F
I am trying to call a DTS package in C# for the first time.  I get the below
compilation error related to the using Microsoft.SqlServer.DTSPkg80.  I am
still on SQL Server 2000 and am only using SDK v1.1.4322.  Visual Studio is
not installed.  Do I need to do something special to clear the assembly
reference error.

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

using Microsoft.SqlServer.DTSPkg80;

Any help would be greatly appreciated.  Thanks.

Author
28 Mar 2007 6:31 PM
Cowboy (Gregory A. Beamer)
Add a reference to the DLL for DTS. I am not sure what that is.

If this is COM, a proxy class will be created and your using statement will
alter slightly (not sure if there is a native .NET DTS class; been awhile
since I have worked with SQL Server 2000).

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*********************************************
Think outside the box!
*********************************************
Show quote
"Chris F" <Chr***@discussions.microsoft.com> wrote in message
news:99E3C6E7-FE20-44F0-ABE7-447E3CADACC0@microsoft.com...
>I am trying to call a DTS package in C# for the first time.  I get the
>below
> compilation error related to the using Microsoft.SqlServer.DTSPkg80.  I am
> still on SQL Server 2000 and am only using SDK v1.1.4322.  Visual Studio
> is
> not installed.  Do I need to do something special to clear the assembly
> reference error.
>
> "CS0234: The type or namespace name 'SqlServer' does not exist in the
> class
> or namespace 'Microsoft' (are you missing an assembly reference?)" related
>
> using Microsoft.SqlServer.DTSPkg80;
>
> Any help would be greatly appreciated.  Thanks.
Author
29 Mar 2007 2:02 PM
Chris F
Thanks.  Can you recommend a good site to research the specific assembly
reference that is required?  Thanks.

Show quote
"Cowboy (Gregory A. Beamer)" wrote:

> Add a reference to the DLL for DTS. I am not sure what that is.
>
> If this is COM, a proxy class will be created and your using statement will
> alter slightly (not sure if there is a native .NET DTS class; been awhile
> since I have worked with SQL Server 2000).
>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
>
> *********************************************
> Think outside the box!
> *********************************************
> "Chris F" <Chr***@discussions.microsoft.com> wrote in message
> news:99E3C6E7-FE20-44F0-ABE7-447E3CADACC0@microsoft.com...
> >I am trying to call a DTS package in C# for the first time.  I get the
> >below
> > compilation error related to the using Microsoft.SqlServer.DTSPkg80.  I am
> > still on SQL Server 2000 and am only using SDK v1.1.4322.  Visual Studio
> > is
> > not installed.  Do I need to do something special to clear the assembly
> > reference error.
> >
> > "CS0234: The type or namespace name 'SqlServer' does not exist in the
> > class
> > or namespace 'Microsoft' (are you missing an assembly reference?)" related
> >
> > using Microsoft.SqlServer.DTSPkg80;
> >
> > Any help would be greatly appreciated.  Thanks.
>

AddThis Social Bookmark Button