PRB: Unable to See VIEWs Using Query Builder in DTS Import/Export Wizard (232984)
The information in this article applies to:
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 <view_name>
| Modification Type: | Major | Last Reviewed: | 10/27/2000 |
|---|
| Keywords: | kbprb KB232984 |
|---|
|