Migrating To Attain 3.60 Using SQL Server

sc00by

Hi,

I'm new to the Navision world and am having some troubles in loading my legacy data (extracted in flat files) into Navision (SQL Server 2000). The problem seems to be where Navision doesn't like NULL values - thus my BCP process fails on the NULL constraints.

I suppose I can get around this by using dataports, however, we have 20 million rows to load into the interaction log and this may take some time!

Any ideas or tips would be greatly appreciated.

Rob Lord.

M@rtin

You try OFF Contsraint on column.

Alter Table Test
NOCHECK
Contraint CN_TestConstraint

then you try insert data. If will good then ON Contraint
Alter Table Test
CHECK
Contraint CN_TestConstraint

Contraint "Primary key and Unique" cannot be off.
Stored procedure which help you: sp_helpconstraint table_name

I cannot tell if help you :?:

Martin