CODEWITHSUNDEEP
sql-serversql-server-2008t-sqlssistransaction-isolation
shockwave
shockwave

Reputation: 3272

SSIS data flow task executing before previous task completes its SQL operation

In SSIS I have DataFlowTask1 which will insert the data into TABLE A. The following data flow task will pull the data from TABLE A. But unfortunately, DataFlowTask2 is getting fired before the DataFlowTask1 has completed inserting the data. Is there any commit happening? How should I ensure that the following data flow starts once the previous task has completed a SQL operation?

Also, what are TransactionOption and Isolation level properties in SSIS. Will any of these properties help solve my problem?

enter image description here

Upvotes: 0

Views: 1673

Answers (1)

TheEsnSiavashi
TheEsnSiavashi

Reputation: 1255

Based on what you said in your comments, I think this is what has happened: when you copy-paste objects from one Data Flow Task to another one in the same package, SSIS sometimes does not automatically assign to that object a new ID. So SSIS does not realize that they are two objects and therefore does not execute one before the other one. Two options:

  1. Check the IDs of your objects (specifically the objects you have copied) See if they have same IDs.
  2. Just do not copy-paste. Do everything by dragging and dropping brand new objects.

Hope this helps.

Upvotes: 1

Related Questions