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 2005 Forums
 SSIS and Import/Export (2005)
 generating sequence numbers in target table

Author  Topic 

varalakshmi
Yak Posting Veteran

98 Posts

Posted - 2007-12-04 : 07:00:34
Hi,
What transformations can be used to generate sequence numbers in a data flow?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-04 : 07:10:12
ROW_NUMBER().


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

varalakshmi
Yak Posting Veteran

98 Posts

Posted - 2007-12-04 : 07:15:08
Is row_number() available in SSIS?
In which transformation?
Or should write some script?
Go to Top of Page
   

- Advertisement -