1 Answer
1

Use a SQL query to find the maximum - why use these tasks? Your problems though...maybe I don't want to understand ;)

My constraint is like ,I cant change
the query(to select the max datetime
from query itself).

Other soluton will be like using a
execute SQL Task to get the latest
datetime (within the DFD executable).

So you can't change your query, but you can create a new one? If you put those two tasks in a transaction container and set it correctly, transactions will take effect and stop an insert from happening until after you are done.

Ya :) we all work with some constraints rite ...Sam what you mean by a transaction container here?
–
Rohith NairJan 25 '11 at 10:39

Sam, Can I use two selects(One for selecting ) and one select to select max date and ensure that both will be in sync.(I read from MS forums like:order of execution of components at same level depends on the execution engine).So I was a bit concerned about using the execute SQL task to get the max date with in the DFD.And my DFD's are inside a sequence container(Is that what you meant by transaction container?)
–
Rohith NairJan 25 '11 at 10:43

If you put those two tasks in a transaction container and set it correctly, transactions will take effect and stop an insert from happening until after you are done. Chris...can you elaborate on this..Thanks
–
Rohith NairJan 31 '11 at 9:35