Wed 3 Feb 2010
A quick tip for those that may want some better organization over the default provided by BIDS when working with SSIS packages.
You can add your own groupings to the Toolbox window by right-clicking anywhere in the toolbox, and selecting “Add Tab”.
For example, in the data flow window, I can add a new tab (or grouping) for Analysis Services Destination components.
1) Right click on the toolbox background and select “Add Tab”
Add Tab
2) Give it a name.
Name Tab
3) Drag components to the new tab.
Dragging Components
4) Repeat as needed.
Repeat
The final results might look something like this:
Final Results
February 6th, 2010 at 4:15 pm
I also like to rename the toolbox items using the Task/Transformation naming conventions proposed by Jamie Thompson some years ago, e.g. SQL Task becomes “SQL – SQL Task”, Lookup becomes “LKP – Lookup”, etc.
[The link to Jamie's recommendations is now broken, or I would post it.]
This makes it easy to remember (and use) a naming convention.
I only wish I could find where BIDS stores this information; it’s pretty tedious to set up on multiple machines.
February 8th, 2010 at 10:25 pm
In BIDS, Tools menu, Import and Export Settings. Get your preferred configuration all set in one BIDS, export to a .vssettings file in a location of your choice. In other BIDS, use import.
February 10th, 2010 at 7:22 pm
Well, I’ll be danged. There it is.
Thanks.