Call DTS using C#

[Guest]

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 \(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!
*********************************************

 

[Guest]

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