Monday, July 20, 2009

Stupid SSIS variable list bug

  1. Bring up the variable list and start editing the name of the first variable
  2. Click the Name column of the variable list to sort the list
  3. Hit Escape to cancel the edit

The variable name you were editing has now replaced the name of the variable that was top of the list after your sort! Cancelling the edit didn't stop this from happening.

Workaround: remember and reenter the variable name that was overwritten. Bleagh.

2 comments:

Unknown said...

Is there also a bug on the list of variables? I can only "see" 6 variables in the drop list of "SQL command from variable"...
Any ideas?

oscil8er said...

Uhm haven't heard of that one before...