Share via

Provide a Source Query (SQL Server Import and Export Wizard)

  • Article

Use the Provide a Source Query page to type the SQL statement that will generate the data to copy from the data source to the destination.

To learn more about this wizard, see Creating Packages Using the SQL Server Import and Export Wizard. To learn about the options for starting the wizard, as well as the permissions required to run the wizard successfully, see How to: Start the SQL Server Import and Export Wizard.

The purpose of the SQL Server Import and Export Wizard is to copy data from a source to a destination. The wizard can also create a destination database and destination tables for you. However, if you have to copy multiple databases or tables, or other kinds of database objects, you should use the Copy Database Wizard instead. For more information, see Using the Copy Database Wizard.

Options

  • SQL statement
    Type a query statement to retrieve selected rows of data from the source database. For example, the following query statement retrieves the SalesPersonID, SalesQuota, and SalesYTD from the AdventureWorks database for sales persons whose commission percentage is more than 1.5 percent.

    SELECT SalesPersonID, SalesQuota, SalesYTD
FROM Sales.SalesPerson
WHERE CommissionPct > 0.015
  • Parse
    Checks the syntax of the SQL statement in the Query statement text box.
  • Browse
    Select a file containing a SQL statement by using the Open dialog box. Selecting a file copies the text from the file into the Query statement text box.

Change History

Release History

17 July 2006
Changed content:
  • Corrected text of sample query.