The SQL Server service account was not granted read permission to the folder. When we granted it read permission to the folder, the bulk insert ran successfully. 

Thanks!

Thanks. We've discovered that the table we are updating has update trigger. When we disabled the trigger the UPDATE statement ran faster.

Thanks! I'll try it.

Hi, I think the solution to this requires more than just 1 step or query.  I had a bit similar requirement before that also gave me a hard time.  But your...

I think there is no direct command in SQL that will do what you require.  I think you will have to create a new table and insert the result of your query.  That...