Post reply

Script Task (How to prompt user for a folder or file location?)

  • June 25, 2008 at 2:16 am

    #183977

    Hi,

    I want to run a Script Task that prompts for a folder or file path. Then use the result to run a package that extracts data from the specified path. Can someone provide me a sample code for this case? Thanks!

  • June 25, 2008 at 7:38 am

    #833944

    SSIS is not designed for and should not be used for processes that have to stop mid-stream and wait for user input.

    Modify your package to use a package variable and prompt the user for the input before starting the package - then you can pass in the information through the SET values in the package. Also keep in mind that an SSIS package can only be run on an SSIS Server. If you include an SSIS package in an application and the application runs locally on a users workstation, you will have to install an SSIS server on each workstation that runs the package (and license it).

    If you have a workflow that needs input mid-stream, I would suggest you look into a business workflow package like BizTalk.

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

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