Close





Lost Password?
No account yet? Register
Increase font size Default font size Decrease font size Narrow screen resolution Wide screen resolution Auto adjust screen size default color red color blue color yellow color orange color

Loading Data into MS Sql Server Database

All our ETL tools are capable of loading data into Ms Sql Server Databases

There two ways to load data in to  Ms Sql Server Databases

  • Create ODBC DSN and load data via ODBC
  • Use BCP which is much faster

This article describes loading data via BCP.

Note:

  •  Some ETL Vendors use MS SQL Server OLE Db provider. We do not use it because it is incredibly slow and requires a lot of resources

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.

Keep NULLS
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 a row at a time. Each row that fails is counted as 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 rollback.
 

Testimonials

"I needed to integrate and automate disparate systems running different database platforms that speak different languages, even different flavors of SQL. Visual Importer products have become that common link for me."

Gene Kovacs,
Director of Technical Business Operations,
A2B

 

Free Newsletter

Please provide your Name and Email address so that we can tell you about latest releases, new features and free offers.






b.150.100.16777215.0..Screenshots.VimpEnt.vimpagent.jpg
DB Software Laboratory - Intel Software PartnerDB Software Laboratory - My SQL Ready Partner
DB Software Laboratory Embacadero Technology Partner