specifying columns in bcp - 08-03-2006 , 07:42 AM
While reading a textfile using BCP can we specify the column names.
The actual situation i am in is i have a number of text files which
have to be read into a single table. and all the text files have the
first 20 columns in common, the rest is different from file to file. i
need only those 20 columns into my table. is there any option with BCP
to get over this.
RE: specifying columns in bcp - 08-04-2006 , 10:38 AM
try creating activex script in DTS package