thanx in advance.....
Pls suggest an idea to import derived fields from the data file to SQLServer2005 using the BCP utility?
eg: in the data file there are
Location UserLocId
USA 1
USA 2
IND 1
IND 2
I have to import Unique usercode like
'USA_1'
'USA_2'
'IND_1'
'IND_2'
...