Phil Parkin (5/20/2013)
greeshatu (5/20/2013)
Select and Update are running paralelly .. this is because I have used Balance data distributor to run the tasks parallely .Which asyncronous transformations is helpful in this case.kindly suggestYou might be better off selecting to a Raw file and updating from that - to ensure that you avoid contention issues.
Raw file is a great idea Phil! Probably better than an asynchronous component in most cases. That said, if your'e only dealing with a smaller data set, add a Sort component. It should not add too much time to the overall processing and should do the trick as well.
But I do like the Raw file very much!