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.


About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

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 , , , , , , , , , , , , , . Bookmark the permalink. 2 Comments.

What are your thoughts?

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: