The SQL Server Import and Export Wizard (DTSWizard.exe) is a component of Integration Services. The SQL Server Import and Export Wizard enables you to migrate data to and from the following sources:
– .NET Framework Data Provider for SQLServer
– Flat File Source
– Microsoft Access
– Microsoft Excel
– Microsoft OLE DB Provider for Analysis Services 11.0
– Microsoft OLE DB Provider for Oracle
– Microsoft OLE DB Provider for SQL Server
– SQL Server Native Client 11.0
The Import and Export Wizard works by creating an Integration Services package.Integration Services enables you to perform complex data transformation tasks that are beyond the scope of the 70-462 exam. The benefit of an Integration Services package, though, is that you can schedule it to run on a regular basis and modify it as necessary by using SQL Server Data Tools.

The following permissions are required to use the SQL Server Import and Export Wizard:
– Permission to read from the source database or file.
– Permission to write data to the destination database or file.
– To save the Integration Services package created by the wizard, the security principal requires INSERT permission on the msdb database.
– If it is necessary to create a new database or table to complete the wizard, the appropriate permissions are required on the destination database instance.
When you deploy Integration Services on a computer that has a 64-bit operating system, Integration Services installs an x64 version of the SQL Server Import and Export Wizard. In some cases, this might cause problems when connections are made to data sources that use 32-bit providers, such as a 32-bit version of Microsoft Access. To resolve this issue, choose to install either the Client Tools or SQL Server Data Tools (SSDT) shared features during the SQL Server setup process.
To use the SQL Server Import and Export Wizard to export data from a database hosted on a SQL Server 2012 Database Engine instance, perform the following steps:
1. In SQL Server Management Studio, right-click the database from which you want to export data. Choose Tasks and then select Export Data. This launches the SQL Server Import and Export Wizard.
2. On the Choose A Data Source page, shown in Figure 4-12, choose the data source from which you want to export data. If necessary, provide alternate authentication credentials.
Using SQL Server Import and Export Wizard

FIGURE 4-12 Choose A Data Source page

3. On the Destination page, choose the destination type, server name, authentication credentials, and, if the destination type supports it, a target database or a new database.
4. On the Specify Table Copy Or Query page, shown in Figure 4-13, choose whether you want to copy data from one or more tables or views within the source database or want to create a custom query to limit the source data that you export by using the wizard. You can choose all tables and views in the source database.

Using SQL Server Import and Export Wizard

FIGURE 4-13 Specify Table Copy Or Query page

5. You can select a table or view and click Edit Mappings to modify the properties of the destination table on a per-column basis, as shown in Figure 4-14. Note that you cannot perform column transformations by using the Import and Export Wizard. If you must perform transformations when exporting data, you should create an Integration Services package.

Using SQL Server Import and Export Wizard

FIGURE 4-14 Column mappings

6. On the Save And Run Package page, choose whether to run the package immediately. You can also save the Integration Services package generated by the wizard to either the SQL Server instance or the file system.