I have a user defined table, @OM_COMMISSIONJOB, which contains three columns:
Code - nvarchar(30) - not null
name - nvarchar(30) - not null
U_OM_DateAdded - Datetime
We have created a CSV file with about 1400 records that looks like this:
As you can see, name and code are always the same.
When I try to process this through DTW it shows errors for every row stating that Name cannot be NULL.
The error file looks like this (stopped after 10 errors – if not DTW crashes after 39 items):
<-----Do not fill this row------->
This makes no sense given that the Name column seems to not exist.
I also saved the file as a Tab delimited file. In this case the import ran without error but left the date field NULL. In this case it seems to "lose" the date field and can proceed because that field allows null values.
Can anyone help?