https://docs.microsoft.com/en-us/ans...rmisisons.html

I recently used bulk insert but don't remember anything special but then I owned the database