BLOG

bcp Utility (bulk copy program) in SQL Server

07-01-2019  0 Comment(s)

The Bulk copy program aka bcp is the console application used to export and import data from text files to SQL Server or vice versa.

It is very popular because it is fast and easy to download.

This tool is installed by default with SQL Server. It is usually installed in the following path:

Drive: \\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\bcp.exe

In this article we will learn how to:

  1. Get the bcp arguments
  2. Get the version
  3. Export data from a SQL Server table to a file
  4. Export data from a SQL Server query to a file
  5. Run bcp using PowerShell
  6. Run bcp on SSIS
  7. Invoke a batch file in SSIS

Requirements

  1. SQL Server installed
  2. bcp installed
  3. The Adventureworks database installed
  4. SSIS Installed
  5. SSDT installed

Comment Here

Comments

No Comments to Show

WE ALWAYS WORK WITH :