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 |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2008-01-25 : 00:22:20
|
| Hi,I have an error table that is to be updated by more than one package.There is a sequence number generated in the error table. It is generated by using the max value of the previous data present in the table.When more than one package runs parallely, conflict occurs in generating the sequence number.How can this be handled? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-25 : 09:10:20
|
| What is purpose behind generation of sequence number? Are you actually trying for generation of unique value for table? If yes, then try appending the execution ID of package to current number. It will always be unique for a package. |
 |
|
|
|
|
|
sequence number generation