Post reply

Is it possible to set a variable from within an Execute Package Task?

  • December 22, 2008 at 4:08 am

    #127625

    Hi all - can anyone tell me if there's a way to directly set a variable by the 'Execute Package task'?

    I have a logging package and I want to set the logging type, description etc whenever it is called. Currently I have a 'script task' to set the variables and an 'execute sql task' to call the package and link them via parent/child configurations. Do I have to have 2 tasks each time i want to log something? The design window is getting a bit messy.

    Thanks, Jon

  • December 22, 2008 at 6:35 am

    #916108

    jonathan.strauss (12/22/2008)

    Hi all - can anyone tell me if there's a way to directly set a variable by the 'Execute Package task'?

    I have a logging package and I want to set the logging type, description etc whenever it is called. Currently I have a 'script task' to set the variables and an 'execute sql task' to call the package and link them via parent/child configurations. Do I have to have 2 tasks each time i want to log something? The design window is getting a bit messy.

    Thanks, Jon

    The standard Execute Package Task doesn't support variables setup. You can check CozyRoc Package Connection. It does support variables setup and you can even get access to the package object if needed.

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

  • December 23, 2008 at 8:59 am

    #916831

    OK, many thanks....

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

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