Database Import Problem "empty strings" instead of "NULL"

[Octron66x]

Hi, I'm using the database import wizard of Installshield 2008 on a MS SQLServer Express 2005. My problem is: Database fields which are set to NULL in the source DB are imported as ''. This causes problems on the target DB. The program on the target machine which accesses the DB is not able to handle ''.

I’m not able to modify the accessing program!

Is it possible to change this import behavior in Installshield or on the SQL Server Express?

What interface is Installshield 2008 using to access the DB? SMO or DMO?
Thanx for help!

[hidenori]

Is the field type a text, ntext, varchar, or nvarchar? If so, please follow the steps below to change the behavior:

[LIST=1]

Open settings.xml under C:\Program Files\Macrovision\IS2008\Support folder in Notepad.exe

Find DevStudio/IDE/Workspaces/SQLScripts/DBImport_ColumnType tag

Change the Nullable property from 'N' to 'Y' for the field type(s) that you have the problem with.

Save settings.xml

Import your database.

[Octron66x]

Thanx, now it works!!!

But I'm asking my self why there isn't any hint in the "DB Import" section of the Manual/Help?

Regards Octron66x