How to put the SSIS Import/Export Wizard on Your Desktop?

Execute the following steps to create a shortcut on the desktop or quick launch toolbar for the Microsoft SSIS Import/Export Wizard:

1. Open the folder where SSIS is installed. The default location is: C:\Program Files\Microsoft SQL Server\100\DTS\Binn
2. Right click on DTSWizard and select shortcut (finished, it appears on desktop), or drag/drop it to the task bar in the quick launch toolbar
3. When the context menu pops up, select Create a shortcut here
4. Click on name below desktop icon, rename to "SSIS 2008 Wizard"

Wizard can also be launched the following ways:

SSMS --> Object Explorer --> Right Click on DB --> Tasks --> Import Data

SSMS --> Object Explorer --> Right Click on DB --> Tasks --> Export Data

Related video: http://www.youtube.com/watch?v=9Wmdhnx1niU

Related articles:

Using the SQL Server Import and Export Wizard to Move Data

How to: Run the SQL Server Import and Export Wizard

SQL Server 2005 Import / Export Wizard

SQL 301 — SSIS Import And Export Wizard by Shannon Lowder

SQL Server DBA Checklist