Using the Bulk Insert Command - property_attributes_assessment

Bulk insert command to load state and sample datafiles:

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
PAD.dbo.asmt
FROM
'C:\Property_Attributes_Assessment\Property_Attributes_Assessment_Data\
Property_Attributes_Assessment'
WITH (FORMATFILE = 'C:\Property_Attributes_Assessment\asmt.FMT',
FIRSTROW = 1,
BATCHSIZE = 1000000,
ROWS_PER_BATCH = 5000000,
ERRORFILE = 'C:\Property_Attributes_Assessment\abc.log',
MAXERRORS = 5000000
)

Bulk insert command to load nationwide datafiles (to skip first record as it is a header/column record):

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

Example for Change Log (state data):

BULK INSERT
PAD.dbo.asmt_change_log FROM 'F:\ Property_Attributes_Assessment\Property_Attributes_Assessment_Data\
property_attributes_assessment_changelog_usa.txt' WITH
(
FORMATFILE = 'F:\ Property_Attributes_Assessment\Property_Attributes_Assessment_Data\change_asmt_fmt.fmt',
FIRSTROW = 1,
BATCHSIZE = 1000000,
ROWS_PER_BATCH = 500000,
ERRORFILE = 'F:\ Property_Attributes_Assessment\Property_Attributes_Assessment_Data\Change_ASMT_error.log',
MAXERRORS = 5000000
)

Example for Change Log (nationwide data):

BULK INSERT
PAD.dbo.asmt_change_log
FROM 'F:\ Property_Attributes_Assessment\Property_Attributes_Assessment_Data\
property_attributes_assessment_changelog_usa.txt' WITH
(
FORMATFILE = 'F:\ Property_Attributes_Assessment\Property_Attributes_Assessment_Data\change_asmt_fmt.fmt',
FIRSTROW = 2,
BATCHSIZE = 1000000,
ROWS_PER_BATCH = 500000,
ERRORFILE = 'F:\ Property_Attributes_Assessment\Property_Attributes_Assessment_Data\Change_ASMT_error.log',
MAXERRORS = 5000000
)

Example for Assessment Field Value Key file:

BULK INSERT
PAD.dbo.asmt_field_value_key
FROM 'E:\PAD\property_attributes_assessment_field_value_key_usa.txt' WITH
(
FORMATFILE = 'E:\PAD\asmt_field_value_key.fmt',
FIRSTROW = 2,
BATCHSIZE = 1000000,
ROWS_PER_BATCH = 500000,
ERRORFILE = 'E:\PAD\asmt_field_value_error.log',
MAXERRORS = 5000000
)

Using the Bulk Insert Command - property_attributes_assessment - Latest

Property Attributes Assessment Getting Started Guide