Integration Services Wizards

Microsoft SQL Server 2005 Integration Services (SSIS) includes a set of wizards that guide you though the steps to copy data between data sources, construct simple packages, create package configurations, deploy Integration Services projects, and migrate SQL Server 2000 DTS packages.

SQL Server Import and Export Wizard

The SQL Server Import and Export Wizard provides the simplest method of constructing basic packages and copying data between data sources.

Note

On a 64-bit computer, Integration Services installs both a 32-bit and a 64-bit version of the SQL Server Import and Export Wizard (DTSWizard.exe).

You can connect to the following data sources:

  • SQL Server
  • Flat files
  • Microsoft Access
  • Microsoft Excel
  • Other OLE DB providers

These data sources can be used as either sources or destinations. You can also use ADO.NET providers as sources.

After specifying the source and destination, you can select the data to import or export.

Depending on the source and destination types, you set different wizard options. For example, if you are copying data between SQL Server databases, you specify the tables or views from which to copy data, or provide an SQL statement that selects the data.

You can run the SQL Server Import and Export Wizard from SQL Server Management Studio and Business Intelligence Development Studio.

To run the SQL Server Import and Export Wizard from SQL Server Management Studio

  1. Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

  2. In the Connect to Server dialog box, select Database Engine in the Server type list, and then click Connect. Depending on the authentication method, provide a user name and password.

  3. Expand the Databases folder, right-click the database from which you want to import or export data, point to Tasks, and then click either Import Data or Export Data.

To run the SQL Server Import and Export Wizard from Business Intelligence Development Studio

  1. Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click Business Intelligence Development Studio.

  2. In Business Intelligence Development Studio, click Open on the File menu, and locate the Integration Services project from which you want to run the wizard.

  3. Right-click the SSIS Packages folder and then click SSIS Import and Export Wizard.

Some wizard features work differently, depending on the environment from which you invoke the wizard. For example, if you run the SQL Server Import and Export Wizard from Business Intelligence Development Studio, the wizard does not provide the option to run the package immediately. Instead the package is added to the Integration Services project from which you ran the wizard, and you can run the package later.

For more information, see Creating Packages Using the SQL Server Import and Export Wizard.

Package Installation Wizard

The Package Installation Wizard guides you through the process of deploying packages and updating package configurations.

Before you deploy packages, you can create configurations and then deploy them with the packages. Integration Services uses configurations to dynamically update properties of packages and package objects at run time. For example, the connection string of an OLE DB connection can be set dynamically at run time by providing a configuration that maps a value to the property that contains the connection string.

You cannot run the Package Installation Wizard until you build an Integration Services project and create a deployment utility. For more information, see Deploying Integration Services Packages.

Package Configuration Wizard

The Package Configuration Wizard guides you though the steps to create the configurations that update the values of properties of packages and package objects at run time.

For more information, see Creating Package Configurations.

Package Migration Wizard

The Package Migration Wizard guides you though the steps to migrate SQL Server 2000 DTS packages to SQL Server 2005. You can migrate SQL Server 2000 DTS packages that are stored in a SQL Server 2000 msdb database, in Meta Data Services, or in structured storage files. The packages can be migrated to the file system as .dtsx files or to the SQL Server 2005 msdb database.

You can run the Package Migration Wizard from SQL Server Management Studio and Business Intelligence Development Studio.

To run the Package Migration Wizard from SQL Server Management Studio

  1. Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

  2. In the Connect to Server dialog box, select Database Engine in the Server type list, and then click Connect.

  3. Expand the DTS 2000 Packages folder, right-click the package you want to migrate, and then click Migrate DTS 2000 Package.

To run the Package Migration Wizard from Business Intelligence Development Studio

  1. Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click Business Intelligence Development Studio.

  2. In Business Intelligence Development Studio, click Open on the File menu, and locate the Integration Services project from which you want to run the wizard.

  3. Right-click the SSIS Packages folder and then click Migrate DTS 2000 Packages.

For more information, see Migrating Data Transformation Services Packages and Using the Package Migration Wizard.

See Also

Other Resources

Integration Services Tools and Utilities

Help and Information

Getting SQL Server 2005 Assistance