473,809 Members | 2,740 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

where are the DTS classes?

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?
Nov 18 '05 #1
4 1321
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?

Nov 18 '05 #2
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
Nov 18 '05 #3
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*****@freewa yprojects.com> wrote in message
news:cn******** ***********@new s.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
Nov 18 '05 #4
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******** ******@TK2MSFTN GP11.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*****@freewa yprojects.com> wrote in message
news:cn******** ***********@new s.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

Nov 18 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2033
by: eBob.com | last post by:
Well I am now on page 84 of Bruce Eckel's "Thinking in Java". (... having made significant progress since the help you guys gave me in response to my last question about page 34.) Here he presents a simple program which uses two classes, System and Runtime. And he suggests using packages.html to find those two classes. He says "If you look at the packages.html file, you'll see a list of all the different class libraries that come with...
2
2425
by: CoolPint | last post by:
Standard exception classes in C++ have what() which returns const char * and they have constructors accepting string. Where is that string created and when is the string destroyed? In the function below, e is a local object so when the function terminates, the internal string should be gone too, isn't it?
5
8692
by: Hans De Schrijver | last post by:
Where can I find a list of pre-defined exceptions for .NET? Whenever possible, I'd rather use existing exception constants rather than defining my own, unless no suitable one has been predefined. Any help would be greatly appreciated. -- Hans De Schrijver
6
1187
by: Dica | last post by:
i've been asked to write an app making use of reports.vb class, but i can't seem to find it..
46
2523
by: clintonG | last post by:
Documentation tells me how but not when, why or where... <%= Clinton Gallagher http://msdn2.microsoft.com/en-us/library/saxz13w4(VS.80).aspx
24
5373
by: Paul | last post by:
I am taking over an existing app and having trouble understanding their references. They have encapsulated Pear packages in the directory structure like: /site /site/html/Pear.php /site/html/Sigma.php /site/html/Common.php /site/html/Quickform.php /site/html/Quickform/
7
1582
by: Bruce | last post by:
I've been searching for some information on the use of Classes in ASP, but found very little information. I found this http://www.daniweb.com/tutorials/tutorial19997.html . Are there more information somewhere online? Thanks
37
2629
by: Phlip | last post by:
1230987za wrote: Kanze is a classically-trained "unit tester". In some circles "unit" is a QA concept - specifically, if a test fails, you only need to inspect one unit. So "units" are "things which are clearly delimited and accessible to inspection". That should map onto C++ classes - specifically due to overlapping requirements. C++ classes _should_ be "things which are clearly delimited and accessible to inspection". Yet...
4
1114
by: Quek | last post by:
Hi all, I'm really new to Python and I've been reading up some texts on older versions of Python (2.2 to be specific). The text briefly mentioned new style and classic classes. I'd really like to know in the current context of Python 2.5, besides in the cases of multi-inheritance, where would I use new style classes? Is it a norm to use more new style classes even if I don't
3
5490
by: Johnson | last post by:
I just converted an ASP.NET Web Site to be an ASP.NET Web Application project type in Visual Studio 2005. After the conversion, the whole thing still works - it builds and the Web app runs just fine. However, none of the classes are placed explicitly in any namespace. The ASP.NET Web Site project type apparentlyl infers namespace from the site's directory structure. But Visual Studio's conversion process ("Convert to Web Application") does...
0
9721
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10639
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10376
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10383
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7661
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6881
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5550
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5688
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4332
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.