freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] BCP In of data too large fails [NC]

From: "James K. Lowden" <jklowden AT freetds.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] BCP In of data too large fails [NC]
Date: Sun, 23 Aug 2009 17:08:37 -0400

Cedric ROUVRAIS wrote:
>
> Starting copy...
> dblib error: The result is truncated because the conversion/operation
> resulted in overflow. Source data "RDJF TFS CRE -
> AdvisedExportLetterOfCredit" should not exceed 32 chars.
> 1 rows copied.

You can't put 10 pounds of flour in a 5-pound bag. If your data in the
file are longer than fit in the column, don't you expect an error?

Or what's the question?

--jkl

[freetds] rowcount not available? [NC], Cedric ROUVRAIS, 08/13/2009
- Re: [freetds] rowcount not available? [NC], Mittel, Alexander, 08/14/2009
  - Re: [freetds] rowcount not available? [NC], Cedric ROUVRAIS, 08/14/2009
    - Re: [freetds] rowcount not available? [NC], Mittel, Alexander, 08/18/2009
      - Re: [freetds] rowcount not available? [NC], Cedric ROUVRAIS, 08/18/2009
- Re: [freetds] rowcount not available? [NC], James K. Lowden, 08/20/2009
  - Re: [freetds] rowcount not available? [NC], Cedric ROUVRAIS, 08/20/2009
  - [freetds] BCP In of data too large fails [NC], Cedric ROUVRAIS, 08/20/2009
    - Re: [freetds] BCP In of data too large fails [NC], Thompson, Bill D (London), 08/21/2009
      - Re: [freetds] BCP In of data too large fails [NC], Cedric ROUVRAIS, 08/21/2009
        
        Re: [freetds] BCP In of data too large fails [NC], James K. Lowden, 08/23/2009
        
        Re: [freetds] BCP In of data too large fails [NC], Cedric ROUVRAIS, 08/23/2009
        
        Re: [freetds] BCP In of data too large fails [NC], James K. Lowden, 08/24/2009
        Re: [freetds] BCP In of data too large fails [NC], Konrad J Hambrick, 08/24/2009
        Re: [freetds] BCP In of data too large fails [NC], Cedric ROUVRAIS, 08/24/2009
        Re: [freetds] BCP In of data too large fails [NC], Konrad J Hambrick, 08/24/2009
        Re: [freetds] BCP In of data too large fails [NC], Cedric ROUVRAIS, 08/24/2009
        
        Re: [freetds] BCP In of data too large fails [NC], Cedric ROUVRAIS, 08/24/2009
        
        Re: [freetds] BCP In of data too large fails [NC], James K. Lowden, 08/24/2009
        Re: [freetds] BCP In of data too large fails [NC], Cedric ROUVRAIS, 08/24/2009
        
        Re: [freetds] BCP In of data too large fails [NC], Konrad J Hambrick, 08/25/2009