Save Time Reusing Configuration Files with Cut and Paste

In SSIS it is a best practice to name your Connection Manager the same as your Configuration File. You can save yourself some time by using cut and paste from the following screens taking advantage of Windows slow-double-clicking.

Assuming you know how to create Configuration Files, use the Browse button to locate your Configuration File.

After browsing to its location, click once to select the Configuration File

Click a second time but not too fast to select only the Name without the extension of .dtsConfig. Copy it using your favorite method. If you click too quickly, Windows treats it as a double-click and inserts it as your Configuration file name.

When you get back to the Completing the Wizard window you will be able to paste the name right over the default text (Configuration 1) and avoid having to

Now you can enjoy the fruits of having your Connection Manager, Configuration File and your Configuration Name being the same.

This blog is not a lesson on keyboard shortcuts (I’m not the best person to show that) but I have painfully watched others type and mistype enough to know this could help.