0

I have a scheduled SSIS job, before it was executed w/o any problems. Today it stuck at OLE DB Destination, which is trying to populate records to the table on production server. I tried to change the connection which connects to our development server, the table schema on DEV is the same as the one on production server, no idea which it hang up for good.

I do not think table get locked because I could still query against the table.

Cœur
  • 37,241
  • 25
  • 195
  • 267
LONG
  • 4,490
  • 2
  • 17
  • 35

1 Answers1

0

Issue found: Out web user was trying to pulling data from a view that contains that table, after I manually killed that process, the data keeps going through.

LONG
  • 4,490
  • 2
  • 17
  • 35
  • 1
    If you want to prevent this in the future, you can define the view to use WITH NOLOCK when querying the table that got locked. – digital.aaron Feb 10 '17 at 20:07