Using Data Transformation Services, part 4: Using the DTS Designer Objects (continued-2) - Data Transfer Destination
(Page 4 of 10 )
Destination Create an MS Access database application (that is an *.mdb file) in a suitable location. In this tutorial it is named as DTSClient.mdb and located in the C: directory. Drag and drop an MS Access connection to the design pane of the DTS Editor and using the ellipsis button locate the above MS Access file. The configured MS Access connection is as shown here. Clicking OK should complete this process. Sometimes the correct authentication information may be needed.
Next: The Transform Data Task >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
