Calling webpage in DTS Package

  • I created a DTS Package that first truncates a table, exports data into a table from a text file, then calls a cold fusion page. When I execute the package, it runs fine. However, we have it set up so an end user opens a cold fusion page which calls the dts package (command \f dtsrun "filename.dts")

    The DTS package will run but it won't call the web page (which is an ActiveScript task). Any ideas?

  • Do you get any error messages? Turn on package logging to check what it's doing. Also, make sure that the process that will execute has sufficient access rights.

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply