Microsoft SQL Server BCP

Use the Microsoft SQL Server Bulk Copy Process (BCP) connector to perform Bulk Copy operations on a SQL Server database.

Solution Details

Solution Type: Platform Connector
Author: Boomi
Published on: May 16, 2026
Last updated on: May 16, 2026

Get Started

Key Features

Execute bulk insert operations to rapidly load large datasets into SQL Server tables
Export data from SQL Server tables or queries into flat file formats
Configure batch sizes and commit intervals to optimize memory usage during transfers
Support multiple data file formats including native, character, and delimited outputs
Leverage native BCP protocol for significantly faster throughput than standard SQL operations

How it works

The Microsoft SQL Server BCP connector enables high-performance bulk data loading and extraction operations directly against SQL Server databases within the Boomi integration platform. It leverages the native Bulk Copy Program (BCP) utility to efficiently transfer large volumes of data, significantly reducing processing time compared to row-by-row insertion methods. This connector is ideal for data migration, warehouse loading, and batch processing scenarios where speed and throughput are critical. Organizations benefit from streamlined ETL workflows that handle millions of records with minimal overhead and optimized server resource utilization.

Applications Required