How Do I Generate the Destination Primary Key?

[hneal98]

I am very new to BizTalk...

I have destination tables set up and the mapping is set. The only thing I don't have set up is the id fields in each table. These ID's do not exist in the Source.

For very large files, BizTalk splits them up into smaller files. That means each file could potentially have the same id's as a different file. I need to have the ID setup so it uniquely identifies each record for each file since it is all going into the same database.

Anyone have any ideas on how to setup the IDs in BizTalk?

Thanks in Advance...