I had installed SSIS 2008 awhile back, and I have been happily using VS2008 to edit DTSX files. Conveniently, the SSIS 2008 install had set up file associations such taht my DTSX files' right-click menu automatically had "Open" and "Edit" - where "Open" would open it in the GUI dtexec tool, and "Edit" would open it for editing in VS2008. Yesterday, I installed SQL Server Management Studio (SSMS) 2012 Express. (I only installed SSMS and APIs - I did not install localDB or the Express database.) That appears to have wiped out my "Open" and "Edit" options in my right-click menu for my DTSX files. Is there a way to restore the previous behavior without uninstalling SSMS 2012 Express? (I have heard mention that I could run the "repair" option on my SQL Server 2008 install - but I don't want it to reset all of my file associations - just my DTSX links.) It's not a super-big deal, but it was very efficient and convenient to have those two context menu items working... Thanks for any help.

Moral of the story is never use Express editions, they are not for serious users. But you should be able to recover just fine: Click "Start," "Control Panel," "Appearance and Themes." "Select "Folder Options." Select the "File Types" tab. Look under "Registered file types" to find the file extension whose file association you'd like to change. Select "Change." Navigate the "Recommended Programs" and "Other Programs" lists to find the program you wish to associate with the file. Then click "Browse." Navigate to the dtexecUI.exe program and click "Open." Select the check box beside "Always use the selected program to open this kind of file." Click "OK." Repeat these steps to restore your other association which is likely devenv.exe for VS/BIDS.Arthur My Blog