specifying columns in bcp

#1

Hi all

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.

thanks

#2

Hi,
try creating activex script in DTS package

"sri" wrote:

Quote:

Hi all

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.

thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

specifying columns in bcp

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

specifying columns in bcp - 08-03-2006 , 07:42 AM

RE: specifying columns in bcp - 08-04-2006 , 10:38 AM