Microsoft KB Archive/232984

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

Article ID: 232984

Article Last Modified on 10/27/2000

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q232984



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:  Use the option: Use a Query to specify the data to transfer.  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  

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

Keywords: kbprb KB232984

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.