Bulk Insert Command - Latest

GeoEnrichment Risk Getting Started Guide

Product type
Data
Portfolio
Enrich
Product family
Enrich Boundaries > Risk Boundaries
Product
Property Fire Risk
Wildfire Risk
Historical Weather Risk
Coastal Risk
Earth Risk
Flood Risk
GeoEnrichment Risk
Version
Latest
Language
English
Product name
GeoEnrichment Risk
Title
GeoEnrichment Risk Getting Started Guide
Copyright
2024
First publish date
2007
ft:lastEdition
2024-01-16
ft:lastPublication
2024-01-16T12:27:55.247281
BULK INSERT
<database_name>.<schema_name>.<table_name>
FROM '<path>\data_file_name'
WITH (FORMATFILE = '<path>\format_file_name>/FMT',
FIRSTROW = 1,
BATCHSIZE = 1000000,
ROWS PER BATCH = 5000000,
ERRORFILE = '<path>\log_file_name.log',
MAXERRORS = 5000000

Example:

BULK INSERT
distance_to_coast.dbo
FROM 'C:\Distance_to_Coast\Distance_to_Coast\Distance_to_Coast'
WITH (FORMATFILE = 'C:\Distance_to_Coast\dist_to_coast.FMT',
FIRSTROW = 1,
BATCHSIZE = 1000000,
ROWS PER BATCH = 5000000,
ERRORFILE = 'C:\Distance_to_Coast\abc.log',
MAXERRORS = 5000000