Hi All,

I do have a query here. Please help.

When I used BCP to import data from datafile to a table on sqlserver, I do get this error. Please let me know what could be wrong with it.

____________________
Starting copy...
SQLState = 22001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]String data, right truncation
0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.): total 78
_____________________

Command I used is...
bcp DBNAME.OWNER.TABLENAME in sys.log.2003-11-01.csv -c -SSERVERNAME -Uxxxx -PXXXX

I have a file generated everyday (tab-column delimiter and newline-Row Delimiter) with the filename in the format(sys.log.yyyy-mm-dd.csv where dd is the previous day) given above in the command.

What I am trying to do is to automate the process of importing all the files to the sql server as a daily scheduled process/job and at the end of the month another job would analyse the data populated in the table and generate a report.

Please advise. New ideas are most welcome.

Thanks for help in advance.

Cheers,

-Vijay G

__________________
- Vijay G

Here is an error that I caused using 'BCP in.'

SqlStatus = s1000
NativeError = 0
Error: Unexpected EOF in BCD data-file

CREATE TABLE [dbo].[Systems] (
    [System_ID] [int] IDENTITY (1, 1) NOT NULL ,
    [SystemType] [char] (12) NULL ,
    [SysNumber] [char] (12) NULL ,
    [SysAddr] [char] (12) NULL ,
    [StationID] [char] (12) NULL ,
    [Id] [char] (12) NULL ,
    [Pims] [char] (8) NULL ,
    [Location] [varchar] (35) NULL ,
    [Platform_Desc] [varchar] (35) NULL ,
    [Platform_ID] [varchar] (35) NULL ,
    [Platform_Call] [varchar] (35) NULL ,
      [TestNumber] [int]
) ON [PRIMARY]

The trouble was in [TestNumber], or maybe Nulls preceding it.
If [TestNumber] was in the last column or next to last column an error was produced.

When [TestNumber] was moved just past System_Id, the BCP 'in' worked well!

CREATE TABLE [dbo].[Systems] (
    [System_ID] [int] IDENTITY (1, 1) NOT NULL ,
      [TestNumber] [int],
    [SystemType] [char] (12) NULL ,
    [SysNumber] [char] (12) NULL ,
    [SysAddr] [char] (12) NULL ,
    [StationID] [char] (12) NULL ,
    [Id] [char] (12) NULL ,
    [Pims] [char] (8) NULL ,
    [Location] [varchar] (35) NULL ,
    [Platform_Desc] [varchar] (35) NULL ,
    [Platform_ID] [varchar] (35) NULL ,
    [Platform_Call] [varchar] (35) NULL
) ON [PRIMARY]