Post reply

Execute DTS Package using ActiveX script

  • April 14, 2005 at 10:24 am

    #60012

    I have a DTS package called "PROCESS NEW RECORDS", that imports records from an external access mdb database located inside a folder on a network share.

    The DTS package also deletes the access mdb file when processing has completed.

    The DTS package runs as a scheduled job.

    I would like write a script to test whether the access mdb file exists in side the network folder before continuing with processing, otherwise end terminate the DTS package.

    Any ideas?

    Thanks

  • April 15, 2005 at 12:44 am

    #552848

    Take a look at the examples at http://www.sqldts.com to test for file existence.

     

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

  • April 15, 2005 at 10:22 am

    #552958

    Thanks phillcart.

    Found some good scripts which I modified to EXECUTE a DTS package from within a DTS package, after testing for db file existence. 

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

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