How to add DTS to SQL Server Management Studio

How to add DTS to SQL Server Management Studio

There are a couple of ways to access the DTS Import and Export utility in MS SQL Server Management Studio (MSSMS) 2005 and forward.

The first would be to right click on the database name.  Select Tasks and in the sub menu, select either Import Data or Export Data.

The other is to have the tool readily available via your Tools menu option in MSSMS.  To do this take the following steps:

1.)    Go to Tools
2.)    Click External Tools
3.)    Click Add
4.)    Under title, give it a name like DTS Import and Export
5.)    Click the browse button right below the ‘Title’ text box (the square button with the ellipse).
6.)    Navigate to:  C:\Program Files\Microsoft SQL Server\90\DTS\Binn
7.)    Select DTSWizard.exe and click open
8.)    Then click Apply followed by Okay

Now if you go to your tools menu, you will find have the option to open the DTS Import Export Wizard on its own.