Post reply

How to get Current configuration file name and path, package tasks list in execution order and package running path from the Script task in SSIS

  • April 29, 2009 at 3:48 am

    #133554

    Is it possible to get the following from the Script task in SSIS

    1. Current configuration file name and path when it is passed using dtexec command.

    2. Current package tasks list in execution order.

    3. Current package running path.

    Thanks,

    Srini

  • April 29, 2009 at 5:01 am

    #985773

    smadeswaran (4/29/2009)

    Is it possible to get the following from the Script task in SSIS

    1. Current configuration file name and path when it is passed using dtexec command.

    2. Current package tasks list in execution order.

    3. Current package running path.

    Thanks,

    Srini

    Using the standard SSIS framework it is not possible. However check the third-party Package Connection Manager. It does allow access to the current executing package object from which you can find all the other information above.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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