Page 1 of 1

Reading Surrogate Keys from SDKSequences

Posted: Sun Oct 07, 2007 10:28 pm
by adamski
Hi

Can anyone tell me why when I follow the steps the the second post of the linked topic, the ID values are visible when performing a "right click, view data" on the source hash stage, but are not present in the sequenctial file output when the job is run.

viewtopic.php?t=104296

All the data apears to shift one column to the left, so the values end up in the ID column, and the VALUE column is empty.

Thanks

Posted: Sun Oct 07, 2007 10:46 pm
by chulett
That would happen if you failed to mark a Key field as a Key.

Posted: Mon Oct 08, 2007 6:05 am
by adamski
Thanks, that did it.

Too easy to miss the obvious sometimes.