Tips ‘N’ Tricks – SSIS – Define you own Keyboard Shortcuts in SSIS Package Designer
SQL Server Management Studio (SSMS) has various shortcuts. Comparatively, there are less shortcuts in SQL Server Business Intelligence Development Studio (BIDS). However, you can quickly add shortcuts to your BIDS for most of your frequently performed actions. To create a shortcut, follow the below mentioned steps:
Go to Tools | Options
Under Options Window, navigate to Environment | Keyboard
Following screenshot shows the Options window in BIDS.
Following screenshot shows a Keyboard Shortcut defined for Autosize functionality in SSIS Package Designer.
Refer to this article for a detailed step by step instructions for defining Keyboard Shortcuts for Autosize functionality in SSIS Package Designer.
Similar shortcuts can be defined for other types of projects within BIDS like SSAS, SSRS etc.
Note: The above steps are based on SQL Server 2008 R2 Business Intelligence Development Studio.
What is your experience working with Shortcuts in BIDS? Do let me know by leaving a comment below.
Take a look at the other Tips and Tricks in this Series on Tips, Tricks, Techniques, and Shortcuts to Improve Productivity, and Design and Coding Skills.
Posted on May 30, 2012, in BIDS, BIDS Shortcuts, BIDS Tips, Keyboard Shortcuts, SQL Client Tools, SSAS, SSAS Tips, SSIS, SSIS Tips, SSRS, SSRS Tips, Tips 'N' Tricks and tagged BIDS, Formatting, Keyboard Shortcuts, MSBI, Reporting Services, Shortcuts, SQL Server, SQL Server Business Intelligence Development Studio, SSAS, SSIS, SSRS, Tips, Tips and Tricks, Tricks. Bookmark the permalink. 2 Comments.