login

Data Transformation Services

Apress eBooksPublished 1 January 2004
Tony Bain, Baya Pavliashvili, Joseph Sack, Michael Benkovich, Brian Freeman
Citations12

TL;DR

BCP (bulk copy program) and DTS (Data Transformation Services) are two tools SQL Server provides for transferring large amounts of data into or out of the database.

Abstract

At some point in the life of most databases, there is a need to transfer large amounts of data into or out of the database. The two tools SQL Server provides for this task are BCP (bulk copy program) and DTS (Data Transformation Services).

Keywords

Computer Science