May 16, 2002 at 9:32 am
Hello everybody.
I want to call a DTS package in a ASP script. Is it possible ?
Thanks.
May 16, 2002 at 4:32 pm
Without going to much into it it should work just like writing a VB app to execute a DTS package. See the various examples of that, you will have just a few changes to make to get it to work. Sorry I have not tried this myself and would take a bit to get an example but post back and maybe someone will have the chance if I don't get to.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 16, 2002 at 4:39 pm
Not sure about ASP but you could use ASP to call a VB control that executes the package:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspapps_2hb7.asp
May 16, 2002 at 5:01 pm
DTS wrappers are COM based so will work fine. Just found this take a look will help http://www.asp101.com/articles/carvin/dts/default.asp
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 17, 2002 at 12:27 am
Thanks for all.
I think i could do something thanks to you.
😉
May 21, 2002 at 4:03 am
There is a 'cheap and dirty' walkaround ...
Enclose the package into a job, create a table TOTO with a trigger that fires on insert and that executes the job.
In your asp code, jus execute the query
INSERT INTO TOTO (filed1) values 'X'
or
Save your package as DTSRUN format and use dtsrun.exe utility.
(Do not forget to update dtsrun file on changes).
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply