October 14, 2009 at 4:41 pm
I have a package that executes 6 dataflows when run, all the data flows run the same proc at the same time which picks a row from a table and updates a flag in the table so that the other dataflow dont pick the same row , but it doesn't happen like I want. I also tried creating guid to make sure the dataflows dont pick same row it didn't work.I need an idea how I can implement this. urgent please........
October 14, 2009 at 9:11 pm
You'll need to provide more details than simply "it's not working". What is the expected output?
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
October 15, 2009 at 12:35 pm
Agreed....we don't have enough info to help you here. How about posting the code that you are using to 'mark' the row as reserved. It looks to me like you are trying to multi-thread a process and manually managing the process queues inside a table. Post your table DDL, a few sample rows of data, and the SP code and you'll get a better answer. Here's a thread that instructs you on how to post what I've asked for in a readily-consumable form: http://qa.sqlservercentral.com/articles/Best+Practices/61537/"> http://qa.sqlservercentral.com/articles/Best+Practices/61537/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply