Starting SSIS Import and Export Wizard

SSIS Import and Export Wizard is handily available at locations where you would need it. However, unlike its predecessor, DTS Import/Export Wizard, SSIS Import and Export Wizard is not available from the Microsoft SQL Server 2005 program group in the Start menu. In SQL Server Workgroup, Standard, Enterprise, and Developer editions, the SSIS wizard uses the Integration Services engine to drive the data. Following are the locations from which you can start the wizard:

  • DTSWizard.exe file

  • SQL Server Management Studio

  • Business Intelligence Development Studio (BIDS)

You will use different methods to start SSIS Import and Export Wizard while working in the following exercises.

Hands-On: Importing a Flat File into ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.