Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
preethe
Starting Member
3 Posts |
 Posted - 2007-10-06 : 06:16:33
|
| Hi AllWe are facing atable lock issue , while running a SSIS packageWe have two flows . one for insert and other for update into the same target table. The update is done using a procedure. We have disabled the lock table option in the target( in the insert flow) The first set of records which come for updates flow fine.But when the records start coming into the insert flow, the data flow stops.Is this a table lock issue? How do i set the commit interval at the update flow?can someone lpease help me out of this situationThanka and RegardsPreethe |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-06 : 07:38:31
|
Are the two flows running in parallel, or sequentially?Sequentially would be better I reckon  Kristen |
 |
|
|
|
|
|
Table lock issue?