dbTalk Databases Forums  

Re: DTS and ASP.NET

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Re: DTS and ASP.NET in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom Spitzer
 
Posts: n/a

Default Re: DTS and ASP.NET - 08-12-2004 , 01:30 AM






One method is to create a class to manage the DTS calls which incorporates
the DTS objects using .NET's COM Interop capabilities. A useful primer on
this is here:

http://www.c-sharpcorner.com/Code/2002/Sept/DTSnCS.asp

There are some tricks involved, which I don't have handy right now, but you
might try contacting me off-list.

Another way is to create a SQL Agent job or stored procedure that calls
DTSRun, and launch the job (or stored procedure) from ASP.NET. If you're DTS
package writes output somewhere, you can display the output back on your
ASP.NET page.

Tom Spitzer
EC Wise, Inc.
tspitzer (AT) ecwise (DOT) com

"Luis Simões" <LuisSimes (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello,
I have to make a control panel for a couple of dts's.

Let's suppose i want to run a dts that makes the ETL for Enterprises, for
Clients and others...
And let's suppose that in a asp.net i want to say to the DTS'S that they
will only make the ET of each one or the ETL only for companies and ET for
clients.. you know? Customization over the DTS's.

I have already prepared the dts for it and they do just fine running with
dtsrun.

My question is... how can i run and see the running status of the dts's in
a
asp.net web page?

This is really important and urgent.
Any kind of help is welcome!

Best Regards,
Luis Simões




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.