Bulk Insert command - complete - Latest

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

BULK INSERT
consumer_spend.dbo.consumer_spend
FROM
'C:\Consumer_Spend\Consumer_Spend_Data\consumer_spend.txt'
WITH (FORMATFILE = 'C:\Consumer_Spend\consumer_spend.fmt',
FIRSTROW = 1,
BATCHSIZE = 1000000,
ROWS_PER_BATCH = 5000000,
ERRORFILE = 'C:\Consumer_Spend\errorlog.txt',
MAXERRORS = 5000000

BULK INSERT <Table_name>
FROM '<Data_Path>'
WITH (FIRSTROW = 2,
    FIELDTERMINATOR = '|',
    ROWTERMINATOR='\n',
    BATCHSIZE=1000000);

BULK INSERT [dbo].[groundview_update_profile_attribute]
FROM 
'E:\GROUNDVIEW_COMPLETE_USA_2025_TXT\data\geoenrichment\ge_gv_usa_updateprofile.txt'
WITH (FIRSTROW = 2,
    FIELDTERMINATOR = '|',
    ROWTERMINATOR='\n',
    BATCHSIZE=1000000);