|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
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. 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). -- Show quoteGregory 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. 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. > |
|||||||||||||||||||||||