where are the DTS classes?

[kevin bailey]

where are the DTS classes?

are they not in the .NET framework.

and for those of us who do not have visual studio how do we set things up so
that

<%@ Imports namespace="DTS" %>

actually works ok?

[Cowboy (Gregory A. Beamer) - MVP]

DTS is part of the SQL install, not .NET. You can use a Process object to run
dtsrun.exe to run it from .NET if you do not want to figure out all of the
DTS DLLs.

---

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

***************************
Think Outside the Box!
***************************

"kevin bailey" wrote:

where are the DTS classes?

are they not in the .NET framework.

and for those of us who do not have visual studio how do we set things up so
that

<%@ Imports namespace="DTS" %>

actually works ok?

[kevin bailey]

kevin bailey wrote:

where are the DTS classes?

are they not in the .NET framework.

and for those of us who do not have visual studio how do we set things up
so that

<%@ Imports namespace="DTS" %>

actually works ok?

to expand a bit...

there is a cookbook at sqldev.net which says you need to

create a keypair file
create a runtime callable wrapper
register the RGC in the Global Assembly Cache

i should then be able to import the DTS namespace into VB in ASP.NET pages
or in other .NET applications.

is this all really necessary?

all i want to do is to run a DTS package on a database from code in an aspx
page.

kev

[bruce barker]

there is not .net support for dts (a com package). you have to build .net
wrappers for it. VS will do this for you when you add the com reference to
the project. if you do not use VS, see the command line utility tlbimp.exe.
the utiltity (or VS which just calls the utility) produces an interop dll,
which you copy to the bin directory, no need to bother with the gac.
-- bruce (sqlwork.com)

"kevin bailey" <kb*****@freewayprojects.com> wrote in message
news:cn*******************@news.demon.co.uk...
| kevin bailey wrote:
|
| > where are the DTS classes?
| >
| > are they not in the .NET framework.
| >
| > and for those of us who do not have visual studio how do we set things
up
| > so that
| >
| > <%@ Imports namespace="DTS" %>
| >
| > actually works ok?
|
| to expand a bit...
|
| there is a cookbook at sqldev.net which says you need to
|
| create a keypair file
| create a runtime callable wrapper
| register the RGC in the Global Assembly Cache
|
| i should then be able to import the DTS namespace into VB in ASP.NET pages
| or in other .NET applications.
|
| is this all really necessary?
|
| all i want to do is to run a DTS package on a database from code in an
aspx
| page.
|
| kev

[Dino Chiesa [Microsoft]]

so the answer is YES
Today, all of that is really necessary.

With SQL2005 (coming soon to a server near you!) this gets easier. DTS
morphs into Integration Services, and it has a fully managed interface.

Sweet.

-D

"bruce barker" <no***********@safeco.com> wrote in message
news:Ok**************@TK2MSFTNGP11.phx.gbl...

there is not .net support for dts (a com package). you have to build .net
wrappers for it. VS will do this for you when you add the com reference to
the project. if you do not use VS, see the command line utility
tlbimp.exe.
the utiltity (or VS which just calls the utility) produces an interop dll,
which you copy to the bin directory, no need to bother with the gac.
-- bruce (sqlwork.com)

"kevin bailey" <kb*****@freewayprojects.com> wrote in message
news:cn*******************@news.demon.co.uk...
| kevin bailey wrote:
|
| > where are the DTS classes?
| >
| > are they not in the .NET framework.
| >
| > and for those of us who do not have visual studio how do we set things
up
| > so that
| >
| > <%@ Imports namespace="DTS" %>
| >
| > actually works ok?
|
| to expand a bit...
|
| there is a cookbook at sqldev.net which says you need to
|
| create a keypair file
| create a runtime callable wrapper
| register the RGC in the Global Assembly Cache
|
| i should then be able to import the DTS namespace into VB in ASP.NET
pages
| or in other .NET applications.
|
| is this all really necessary?
|
| all i want to do is to run a DTS package on a database from code in an
aspx
| page.
|
| kev