I want to import data from text file.which contain arround lakhs of records

I am using bulk insert do it like this

```
BULK
INSERT vw_bulk_insert_test
FROM '\\server\c$\csvtext.txt'--\\server\SQLEXPRESS\csvtest.txt'
WITH
(FIRSTROW=2,
check_CONSTRAINTS,
FIELDTERMINATOR = '~',
ROWTERMINATOR = '\n'
)
GO

```

But before insert I want to validate values of each column without using cursor.Like if second row will have values of all fields except unit\_number(Column) then it should create a error log specifying unit\_number value is missing.