Using the Bulk Insert Command - property_historical_sales

For Property Historical Sales

BULK INSERT [ database_name]. [ schema_name ] . [ table_name ] FROM 'path\data_file' WITH
 ( FORMATFILE = 'path\*.fmt', FIRSTROW = 1, BATCHSIZE = 1000000, ROWS_PER_BATCH = 500000, 
ERRORFILE = 'path\abc.log', MAXERRORS = 5000000 )

Example:

BULK INSERT
PAD.dbo.prop_hist_sales
FROM 'C:\Property_Historical_Sales_202006_CA\Property_Historical_Sales_202006_CA
\Historical_Sales_Product_Data\06001_Prop_Hist_Sales' WITH (FORMATFILE = 'C:\Property_Historical_Sales_202006_CA\prop_hist_sales.FMT', FIRSTROW = 1,BATCHSIZE = 1000000,
ROWS_PER_BATCH = 500000,ERRORFILE = ' C:\Property_Historical_Sales_202006_CA \abc.log',
MAXERRORS = 5000000 )

The following syntax should be used to load nationwide data:

BULK INSERT
PAD.dbo.asmt
FROM 'C:\
Property_Historical_Sales\Property_Historical_Sales_Data\
Property_Historical_Sales' WITH
(
FORMATFILE = 'C:\Property_Historical_Sales\hist.FMT',
FIRSTROW = 2,
BATCHSIZE = 1000000,
ROWS_PER_BATCH = 500000,
ERRORFILE = ' C:\Property_Historical_Sales\abc.log',
MAXERRORS = 5000000
)

Use the following syntax to load change log data:

BULK INSERT [ database_name]. [ schema_name ] . [ table_name ] FROM 'path\data_file' WITH
 ( FORMATFILE = 'path\*.fmt', FIRSTROW = 1, BATCHSIZE = 1000000, ROWS_PER_BATCH = 500000, 
ERRORFILE = 'path\abc.log', MAXERRORS = 5000000 )

Example:

BULK INSERT
PAD.dbo.prop_hist_sales_change_log
FROM 'C:\Property_ Historical_Sales_202009/Change_Files\Change_Hist_Sales' WITH (FORMATFILE = 'C:\Property_ Historical_Sales_202009\change_hist_sales.FMT', FIRSTROW = 1,BATCHSIZE = 1000000,
ROWS_PER_BATCH = 500000,ERRORFILE = ' C:\Property_ Historical_Sales_202009\abc.log',
MAXERRORS = 5000000)

Using the Bulk Insert Command - property_historical_sales - Latest

Property Historical Sales Getting Started Guide