PRB: Unable to See VIEWs Using Query Builder in DTS Import/Export Wizard

• Microsoft SQL Server version 7.0

SYMPTOMS

There is not an explicit option to transfer views between heterogeneous databases using the Import/Export option in the Data Transformation Services (DTS).

WORKAROUND

DTS is designed to import and export data. Views do not physically contain data, but rather logically define a dataset from one or multiple tables. If you want to create the view on the destination datasource, you need to script the view on the source and run the script on the destination datasource.

However, if you just wish to export the data represented by the view into a table on the destination datasource, you can do the following:

1. Use the option: Use a Query to specify the data to transfer.



2. Do not choose Query Builder. Instead, type the actual SQL statement to perform the transfer. If you want to transfer all of the data from the view, type the following query:

   
   select * from <view_name> 

Additional query words: DTS, Views, Query Builder, Import Wizard

Keywords : kbSQLServ700
Version : winnt:7.0
Platform : winnt
Issue type : kbprb