Setting a variable won't work
After package execution, the variable value reverts to its Design Time value.
To see its Run Time value, you need to put in a Break Point after the varible has been assingned its new value, and open a Watch Window when you hit the breakpoint.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
November 18th, 2010 9:03am