Call DTS using C#

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.

Cowboy
Wed Mar 28 13:31:45 CDT 2007

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" <ChrisF@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.

ChrisF
Thu Mar 29 09:02:03 CDT 2007

Thanks. Can you recommend a good site to research the specific assembly
reference that is required? Thanks.

"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" <ChrisF@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.
>