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.

Adding folders to SSMS project

Problem:

Can't create folders in a SQL Server 2005 Management Studio project.

It would be handy to be able to separate scripts into folders. Unfortunately only three default folders are available: Connections, Queries and Miscellaneous

Workaround:

1. Open the .ssmssqlproj file in a text editor
2. Copy one of the LogicalFolder tags e.g. Miscellaneous
3. Replace the Folder Name and Type. Make sure the Type value is different from all of the existing folders
4. Your new folder(s) should now be available in SSMS

Example insertion:

<LogicalFolder Name="Stored Procedures" Type="4" Sorted="true">
<Items />
</LogicalFolder>