How can i achieve thel following ? I have a staging table filled by import function in SSIS. After that the staging table should compare it's records with a other table. Now it is possible for 5 fields that could have changed, how can I achieve that for
those five fields so if the first has changed up[date the whole record, if the first field hasn't changed, check the second, if that has changed, update the whole recordand so on.
With a conditional slplit you have to settle more splits i quess.
Any help would be appreciated.
View Complete Post