How to create uniqueid(identity column) while importing one text file to another text file with SSIS?
Posted on 2009-02-09
Can you please tell me how to create unique id like identity column value with seed 1 while importing one text file to another text file with SSIS package?
Files has 40 columns and around 50000 records. But these files doesn't have any unique column. So i need to create unique column like identity column with seed 1 before loading into database. So i plan to create another flat file (destination file) along with identity column . Can you please advise me how to do this? My destination database is Netezza and cureent version doesn't have identity column concept.Thanks.