Importing and Exporting Data
Solutions in this chapter:
■ Overview of Data Import and Export Tools
■ Data Transformation Services
■ Creating and Editing DTS Packages
■ Executing DTS Packages
■ The Bulk Copy Program
■ SQL-DMO BulkCopy
■ The BULK INSERT Command
■ Choosing a Data Import and Export Method
Introduction
Transferring and manipulating data was once the job of trained database administrators. With data the driving factor in markets that require reaction time in terms of minutes, having the information available to analyze is the key to making informed and accurate decisions for your organization. Getting data in and out of SQL Server is a common task, and several tools are available in SQL Server 2000 to accomplish this task. Whether it’s ...
Get Designing SQL Server 2000 Databases now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.