• Koen Verbeeck (12/11/2013)


    I think it is quite normal that readers are blocked when a bulk insert operation is going on. This is to prevent dirty reads.

    +1 agreed this is sensible behaviour.

    Maybe your package can be optimised - typically how many rows are you inserting and how long are the locks lasting?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.