Home Forums SQL Server 2005 SQL Server 2005 Integration Services How, where do you use the expression builder at the package builder to write to a Package (Global Variable)? RE: How, where do you use the expression builder at the package builder to write to a Package (Global Variable)?

  • November 7, 2009 at 4:46 pm

    #1076386

    Kent Krug-210111 (11/5/2009)

    Can you concatenate variables at the Package Level like in DTS with Global Variables?

    I don't remember what it was in DTS, but in SSIS it possible to do it in two ways:

    1. You can use expressions. Check this post for more information.

    2. You can use script. The input variables have to be specified in the ReadOnlyVariables property. The output result variable has to be specified in the ReadWriteVariables property.

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