Re: Bulk Insert - How to represent nulls in .txt input file?
From: Sean (none)
Date: 08/25/04
- Next message: Maggie: "DTS error: Cannot import data to column varchar(360)"
- Previous message: Daniel B: "Can't schedule Application using DTS"
- In reply to: Sean: "Bulk Insert - How to represent nulls in .txt input file?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 25 Aug 2004 12:24:43 -0400
On Wed, 25 Aug 2004 12:12:22 -0400, Sean <none> wrote:
>I have a table that I'm loading via .txt file input.
>
>One of the columns has a datatype of datetime. It does allow nulls
>which I've checked by simply adding 1 record via enterprise manager
>with no value in the field.
>
>When I execute the DTS package, I get "conversion error: Conversion
>invalid for datatypes on ...."
>
>This is a comma delimited file with Quotes (") surrounding the values.
>
>I've tried no values ,"",
>
>Blank ," ",
>
>/N ,"/N"
>
><NULL> ,"<NULL>"
>
>and all of them give me the same conversion error. I'm about to give
>up and just pass some bogus date off in the future but there must be a
>way to pass a null to a datetime field that allows nulls.
>
>Any help for this newbie appreciated.
Answering my own question...
I just tried ,, (no quotes) and that worked.
Sean
- Next message: Maggie: "DTS error: Cannot import data to column varchar(360)"
- Previous message: Daniel B: "Can't schedule Application using DTS"
- In reply to: Sean: "Bulk Insert - How to represent nulls in .txt input file?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
