Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Generate unique Integer for each DTS package load

Author  Topic  pandu Starting Member 1 Post Posted - 2005-07-06 : 13:55:23 I am having a very good experience in ETL( with other ETL Tools). I am new to SQL Server 2000 DTS. We are planning to populate a unique integer number to all Warehouse Tables ,for each DTS Package load( i.e., per load). Load means DTS Package run. Eg:- For Load one -> 1, Load two -> 2, .........Load n -> n. Is there any way to do in DTS. Your help is greatly appreciated. Regards Pandu