Bulk insert inserting 0 rows
To get this working:


Change the ROWTERMINATOR to '\n'. I'm not sure why '\r\n' isn't
working, but '\n' works with your example data.
Remove KEEPNULLS. NULL values in the CSV for a nullable column will still be brought through as NULL to the database, but this
prevents the NULL for IMPORT_DATE coming through.
Change IMPORT_DATE to have a DEFAULT value of GETDATE() but leave it as nullable (otherwise the import fails)
Add IMPORT_DATE as a column in the CSV
Add a new line after your last data row to ensure the final field is terminated in a way that SQL can detect when importing.


After these changes, the data imports correctly. NOTE: If you want IMPORT_DATE to come through as NULL instead of using the current date, skip step 3.