Hi,

I have several clients that have data in an Access.mdb. I also have a SQL
server database that has the same tables and fields that exist in the Access
database. I need to import the data from the Access databases into the single
SQL Server database.

What I would like to know is how to handle the primary keys that exist on
each table? I have written an SSIS program that imports all the data in each
Access table to the mirror table in SQL Server. This works great for the
first Access database, however, because the other Access databases have
duplicate primary keys, it is a problem importing the rest.

Can someone tell me if there is a standard way to handle this issue?


--
Jerry J