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.

On Wed, 25 Aug 2004 12:12:22 -0400, Sean <none> wrote:


Answering my own question...

I just tried ,, (no quotes) and that worked.

Sean