datetime tune date into pad dynamic cursor money percent sp job isnumeric while over update
FREE TRIAL  SQL 2012 PROGRAMMING  SEARCH
SQL Server Scripts SQL 2005 SQL 2008 Articles
SQL JOBS NEWS FORMAT DEV JOBS
How to use the SSIS Import/Export Wizard?

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 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

 

Exam Prep 70-461
Exam 70-461