Re: Import From TAB File Error
From: Keith (_at_.)
Date: 04/07/04
- Next message: Andrew J. Kelly: "Re: Minimal configuration, suggestions wanted."
- Previous message: Keith: "Re: Re:Import From TAB File Error"
- In reply to: Sue Hoegemeier: "Re: Import From TAB File Error"
- Next in thread: Adam Machanic: "Re: Import From TAB File Error"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 7 Apr 2004 14:24:15 +0100
I have checked and there is not an extra line at the end of the file!
"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:hsv7705e7u3eg7braj1hhqv5qsk5de57j4@4ax.com...
> There is probably a blank line at the end of the file. You
> could try adding a where clause along the lines of: where
> sic_id is not null.
>
> -Sue
>
> On Wed, 7 Apr 2004 12:26:10 +0100, "Keith" <@.> wrote:
>
> >I am trying to import data into a table in my database using DTS.
> >
> >The table (SYS_DD_SIC_Codes) has the following structure:
> >
> > [SIC_ID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
> > [SIC_Code] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
,
> > [SIC_80] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
> > [SIC_92] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
> >
> >The import procedure works, but then fails at the very last line in the
TAB
> >file, giving an error that it cannot insert a NULL value into [SIC_ID]
for
> >the last line in the TAB file.
> >
> >This is correct as the fields are all NOT NULL, but why is it trying to
> >insert a NULL value when none exist in the TAB file to insert?
> >
>
- Next message: Andrew J. Kelly: "Re: Minimal configuration, suggestions wanted."
- Previous message: Keith: "Re: Re:Import From TAB File Error"
- In reply to: Sue Hoegemeier: "Re: Import From TAB File Error"
- Next in thread: Adam Machanic: "Re: Import From TAB File Error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
