G'day,
I've created a data transformation task to load a delimited text file into a
SQL sever table. Some of the columns of data which have a FK constraint can
have NULL values. This shouldn't be a problem however I'm getting errors on
those records with 'NULL' values. The source file is comma separated and
uses single quotes as the text qualifiers. I've now found that when I use
the text file properties dialogue I can see that blank date and number
fields in the text file (that aren't enclosed in quotes) are being
interpreted as NULL, but empty text fields with '' are NOT being interpreted
as NULLS. I can temporarily get around this problem by leaving the text
qualifiers out of the source file but I'd prefer to leave them in. The
source file is being generated by Crystal Reports.

Can anyone shed any light on this? I would have thought that '' should be
interpreted at NULL.

Thanks.

cheers
peterDavey
Austin Health
Melbourne

Try to use an ActiveX transformation script to transform blank values into
null.

Francesco Anti

"peterDavey" <peter.davey (AT) austin (DOT) org.au> wrote

Francesco,
Thanks for the reply. I was hoping to avoid creating individual
transformations for each column (for performance and maintainability
reasons) and was looking for a global setting that might do the job.
cheers
peterDavey

"Francesco Anti" <fanti @ sicosbt.it> wrote