Ahhh ok yes I am, thanks very much.

Ian Yates (1/20/2008)

---

What if you did your bulk insert into a staging table and then, using normal T-SQL, execute the insert statement selecting from the staging table? You can...

We need to allow reads/updates on the table at the same time as a bulk insert is occuring.

The table lock option is definitely set to 0 in table options,...