Bulk Insert Command - insurance_premium_tax - Latest

Geoenrichment Risk - Insurance Premium Tax Getting Started Guide

Product type
Data
Portfolio
Enrich
Product family
Enrich Boundaries > Risk Boundaries
Product
Insurance Premium Tax
Version
Latest
Language
English
Product name
Geoenrichment Risk Insurance Premium Tax
Title
Geoenrichment Risk - Insurance Premium Tax Getting Started Guide
Copyright
2023
First publish date
2018
ft:lastEdition
2023-07-31
ft:lastPublication
2023-07-31T11:39:57.587584
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
Insurance_Premium_Tax.dbo
FROM 'C:\Insurance_Premium_Tax\Insurance_Premium_Tax_Data\Insurance_Premium_Tax'
WITH (FORMATFILE = 'C:\Insurance_Premium_Tax\Insurance_Premium_Tax.FMT',
FIRSTROW = 1,
BATCHSIZE = 1000000
ROWS_PER_BATCH = 5000000
ERROFILE = 'C:\Insurance_Premium_Tax\abc.log',
MAXERRORS = 5000000