Integration Services Wizards
Microsoft Integration Services includes a set of wizards that guide you through the steps to copy data between data sources, construct simple packages, create package configurations, and deploy Integration Services projects.
Integration Services currently incudes the following wizards:
SQL Server Import and Export Wizard
Integration Services Connections Project Wizard
Package Installation Wizard
Package Configuration Wizard
The SQL Server Import and Export Wizard provides the simplest method of copying data between data sources and of constructing basic packages.
The SQL Server Import and Export Wizard can copy data to and from any data source for which a .NET Framework or a native OLE DB data provider is available. The following data sources are some of the sources for which there is an appropriate data provider:
After specifying the source and destination, you select the data to import or export.
Depending on the source and destination types, you then set additional 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.
Finally, to perform the import or export, you run the Integration Services package that the wizard has created. Optionally, you can save the package, and then use SSIS Designer to extend the package by adding tasks, transformations, and event-driven logic. For more information, see Designing Packages in Business Intelligence Development Studio.
In SQL Server Express, the option to save the package that the wizard creates is not available.
You can start the SQL Server Import and Export Wizard from the Start menu, from SQL Server Management Studio, or from Business Intelligence Development Studio. For more information, see How to: Run the SQL Server Import and Export Wizard.
For a video that demonstrates how to use the SQL Server Import and Export Wizard to create a package that exports data from a SQL Server database to a Microsoft Excel spreadsheet, see Exporting SQL Server Data to Excel (SQL Server Video).
You use the Integration Services Connections Project Wizard to create a package that contains the connection information that is required to connect data sources and destinations. The wizard guides you through the steps of selecting data providers, configuring connection managers, and assigning connection managers to sources and destinations.
For more information, see Creating a Package by Running a 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 Packages by Using the Deployment Utility.
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. This wizard runs when you add a new configuration or modify an existing one in the Package Configurations Organizer dialog box. (To open the Package Configurations Organizer dialog box, in Business Intelligence Development Studio, on the SSIS menu, select Package Configurations.)
For more information, see Creating Package Configurations.