I have a pervasive database that I am trying to import the data into MSSQL.

The are text columns in various tables that appear to be empty(Null) which
in fact contain the control character chr(0). I detrmined this when setting
up the table as a linked table in MS Access. I could I could only query
these fields to obtain the empty ones by using syntax similar to where field
= chr(0).

We were previously importing the data using .net, OdbcDataReader ect, this
copied the data accross in its original form, how ever due to performance we
are now using DTS.

With DTS we are using a TransformDataTask with the Pervasive Table as Source
and the MSSQL table as destination. The problem is we are loosing the value
of the control character, and getting a <NULL> value. What can I do to
bring the required value accross.


Paul