Post reply

SSIS: Running child using DTEXEC but hiding the command window

  • April 12, 2012 at 5:40 am

    #259048

    Hello All,

    Am trying to run list of SSIS child package from Master package using DTEXEC (Execute Process Task). But while running Master Package, it opens number of command window, which seems does not acceptable to client.

    Any solution to hide these black box?

    Regards

    Ritesh

  • April 12, 2012 at 5:43 am

    #1472497

    Use Execute Package tasks instead?

  • April 12, 2012 at 6:57 am

    #1472536

    Thanks for reply.

    Actually am passing parameter to child package, so I have to use Execute Process Task.

    Am I right?

    Regards

    Ritesh

  • April 12, 2012 at 7:04 am

    #1472540

    Ritesh

    Just use an expression to set the name of the package in the Execute Package task. That's equivalent to passing in a parameter.

    John

  • April 12, 2012 at 7:32 am

    #1472568

    Thanks

    Am close but still there is ....

    Child Package to be called is usp_Test1

    Parameter passed: User::ExecutionName with value "usp_Test1"

    So, as per your solution, I gave following expr in Name property

    "usp_Test1.dtsx" + " /Set " + "\\Package.Variables[User::ExecutionName].Value;" + "\"usp_Test1\""

    But gives runtime error

    'The name cannot containany of the following char \ / ; etc.'

    Any idea?

    KD

    Ritesh

  • April 12, 2012 at 7:38 am

    #1472572

    Ritesh

    The package name is just the path and the filename - something like x:\MyDir\MyPackage.dtsx. There are no command line switches. If you need to configure your package you'll need to use one of the Package Configuration options - config file, environment variable, parent package variable and so on.

    John

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

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