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 |
|
fredjonze
Starting Member
1 Post |
 Posted - 2009-10-01 : 11:07:59
|
| Hi,I have a somewhat complex data flow composed of lookups with branches to 'no match' lookups. I then do a union all on the two lookups to get my data flow back to one stream. I do this six separate times to find all of the data I need. I also have several conditional splits with a lookup on one branch that I also re-combine using a Union All.My problem is that I'm getting data corruption in my rows. For instance, I have a value of 'xyz' for row 1234 that is showing up in row 5678 after all of the lookups and union alls have been processed. And, the corruption is not repeatable. I've tried to set up data viewers after each of the unions to find where the data swap might be occurring...as compared with the final data set written to database...but have not been successful. It's almost as if the process of looking through the data viewer is preventing the corruption.Needless to say I'm going nuts. I'm at the point of ditching the UNION ALLs and finding another solution.Has anyone experienced this or have any thoughts? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-01 : 15:28:17
|
| it might be helpful if you could give an overview of your package like tasks involved, order,... |
 |
|
|
|
|
|
Potential data corruption with Union All?