Re: BCP Utility

From: Gert E.R. Drapers (GertD_at_Online.SQLDev.Net)
Date: 06/20/04 

Date: Mon, 21 Jun 2004 00:22:12 +0200

You can't, BCP expects all columns to be present, you will have to write a
pre-processor in Perl or so which adds the missing columns, before BCP will
accept the file.

GertD@SQLDev.Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.

"Jan Aerts" <jae@oce.nl> wrote in message
news:u53bneRVEHA.3516@TK2MSFTNGP10.phx.gbl...
> Hello,
>
> I have a data file with variable record length, each field has fix length,
> but when last fields in record not filled, record is truncated.
> How can I use this file in BCP utility?
>
> Thanks,
>
> Jan
>
>

Relevant Pages

  • Re: Problem directing BCP Error to Error file
    ... Though the bcp in works fine but the error file is not being created ... Why are you asking questions about bcp in a Perl newsgroup? ... helped with your Perl problems a week ago, but it seems the problem you ...
    (comp.lang.perl.misc)
  • Best Way to Update Table?
    ... Use BCP to extact the data to a text file then write perl ... program to update the BCP file. ... brake the table into 4 tables and then process ...
    (microsoft.public.sqlserver.mseq)