Calling DTS with ASP scripts ...

  • Hello everybody.

    I want to call a DTS package in a ASP script. Is it possible ?

    Thanks.

  • 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)

  • 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

  • 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)

  • Thanks for all.

    I think i could do something thanks to you.

    😉

  • 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