DTS add id col to text file

[moley]

hi,

How can i add a unique id to a select qry for text output?
The data sources are from access, oracle, and lotus, so I can't add a row parameter in the sql (3 files).

thanks

 

[SQLDenis]

Throw all in a temp table with an identity column

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/