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 9, 2009 at 9:42 am

    #1076737

    Thanks for sharing this with me.

    The problem that I'm still having is that I can change the value of a User Variable with Package Scope and view the change it break mode.

    However after I stop debugging the original value persist.

    In DTS the value of the Global Variable would be set to value that it was changed to when the Package was run.

    Regards,

    Kent

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/