|
Execute the following
steps to create a shortcut on the desktop or quick launch toolbar for the Microsoft SSIS Import/Export Wizard:
- Open the folder where SSIS is installed. The default location is: C:\Program Files\Microsoft SQL Server\100\DTS\Binn
- 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
- When the context menu pops up, select Create a shortcut here
- 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 videos: http://www.youtube.com/watch?v=9Wmdhnx1niU
http://www.youtube.com/watch?v=Op2zLzaXwWI
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
|