I'm new to DTS and SQL Server, so I appoligize if this is an easy question. I have to query several tables and export the data to an external DB. I need to create a unique ID for each row that is selected from each table. This ID can simply be a row counter. So, if I count 2000 rows from the first table and output them to the external DB file, then the second query needs to start with ID#2001 for its counting. I'd guess that I could query the external DB file to find the max value and pass it to the second step, but don't know how to do that either. Thanks

Max A. Worlund
CDC Information Technology Support Contract (CITS)
Software Engineer III
NCHSTP/SDMB
email:  [email protected]

maxworlund,
if the external DB to which you are trying to export is an SQL DB then you can make the unique ID column as an identity column.

good day