Load data in Microsoft SQL server in just a few clicks. Plus there is no need to create any scripts or learn command line tools just point and click.

 There several ways to load data into Microsoft SQL Server Database

  • Via ODBC
  • Via OLE DB
  • Using BCP interface

This article describes loading data via BCP.

BCP is the fastest way of loading data into SQL Server

MS SQL Server specific parameters

Check constraints
Ensure that any constraints on the destination table are checked during the bulk copy operation. By default, constraints are ignored.

Keep identity
Specify that there are values in the data file for an identity column.

Specify that any columns containing a null value should be retained as null values, even if a default value was specified for that column in the destination table.

Batch size

Specify the number of rows in a batch. The default is the entire data file.

The following values for the Batch size property have these effects:
If you set Batch size to zero, the data is loaded in a single batch. The first row that fails will cause the entire load to be cancelled, and the step fails.
If you set Batch size to one, the data is loaded one row at a time. Each row that fails is counted as a one-row failure. Previously loaded rows are committed.
If you set Batch size to a value greater than one, the data is loaded one batch at a time. Any row that fails in a batch fails that entire batch; loading stops and the step fails. Rows in previously loaded batches are either committed or if the step has joined the package transaction, provisionally retained in the transaction, subject to later commitment or roll-back.

Direct link, no registration required.

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
Swiss banking
Bank Of Oklahoma
Red Cross
Alta Pacific bank
Gas alberta
Royal Brunei
First Oklahoma bank


What customers say about us

  • swissbanking

    I used Advanced ETL Processor in 2 Enterprises for many business processes and Business automation (outside finance department). I did not find any other tool with so many functions and broad flexibility for that Price! If you need support for bugs or solution design you will get it very fast. Best Support I have ever seen.

    Lionel Albrecht
  • iqvia

    IQVIA and DB Software Laboratory (DBSL) partnered in 2010 and have been working in close cooperation ever since. Over this period of time, DBSL software components formed an integral part of a large number of IQVIA applications currently used by over 20 UK NHS Trusts (Hospitals).

    Dmitry Dorsky,
  • xerox

    The product is easy to learn and once a developer understands the ETL way for solving the problem at hand, the developer's productivity will increase. Even our DBAs now uses the ETL software to quickly create solutions instead of SSIS or SQL jobs.

    Daniel Fung
    Solutions Architect

Read ETL Software customers feedback

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies