Flat File Import and Null Values
- From: Gary Helriegel <alhrensblade@xxxxxxxxx>
- Date: Thu, 03 Aug 2006 00:14:59 -0600
Hi all,
This is my first time posting, as well as my first time using DTS. I find myself
in a bit of a quandary. I'm trying to import data from a flatfile into a SQL
database, using the ActiveX VBscript engine. I want the fields which are nothing
but spaces to be true 'null' values in SQL. I'm using a function which sets any
field which contains nothing but spaces equal to "" (empty string). In the case
of the numeric fields, this works perfectly. However, the char and varchar field
types seem to insert an empty value, but not a null. I've got the checkbox for
'keep null values' turned on. How would I go about inserting a null value into
these fields?
Any help would be greatly appreciated.
Thanks in advance,
~Gary
--
Posted via a free Usenet account from http://www.teranews.com
.
- Follow-Ups:
- Re: Flat File Import and Null Values
- From: Davide
- Re: Flat File Import and Null Values
- Prev by Date: Re: Unique destination file name
- Next by Date: Re: Flat File Import and Null Values
- Previous by thread: Re: Unique destination file name
- Next by thread: Re: Flat File Import and Null Values
- Index(es):
Relevant Pages
|
