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)
 Row number in the dataflow task

Author  Topic 

rakesh830
Starting Member

2 Posts

Posted - 2007-06-21 : 05:36:00
Hi all,

I got a text file with two columns. and I need to generate a integer key automatically with the row number (or any distinct number, I thought row number will be OK). and when I make the data flow task to import this text file into a table I need to get the unique rownumber as Id.
How can I make this in the data flow tak??

Rak
   

- Advertisement -