Planning to Use the Import and Export Wizards
The DTS Import and DTS Export wizards offer many features that can be used to customize or simplify the method in which data is copied from source to destination. Before using the DTS Import or DTS Export wizard to create a DTS package, the following features should be considered:
- OLE DB provider advanced properties
- Column mappings
- Data transformation scripts
- Advanced transformation properties
- Transferring data and database objects between computers running Microsoft® SQL Server™ version 7.0
- Saving the DTS package
- DTS package scheduling
(c) 1988-98 Microsoft Corporation. All Rights Reserved.