Discussion Board

DTS and BCP BCP Utility: Bulk Copy Program (BCP) is a command line utility which can be used for exporting SQL server data to text file. It is also used to transfer data from SQL server table to a data file. DTS Packages: Data Transformation Services (DTS) tool is used to export the data from table to textfile. It is a set of tools that allows you extract, transform, and consolidate data from disparate sources into single or multiple destinations. You can create custom data movement solution using DTS object model. DTS package also notifies if package steps succeed or failed by sending mails to source and destination. Prajakta Pandit 03-6-2017 04:34 AM

answer DTS export wizard is the correct answer san 03-30-2015 01:36 AM

oca is this question in oca or in ocp isaiah 08-16-2014 06:23 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*