About a warning

ds · Post by ds » Tue Dec 04, 2007 12:40 am

The following warning arise in my log for a job:

At field "B_Date": "null_field" length (0) must match field's fixed width (3)

i have set 'B_Date' as nullable. It s in date format.
What is the value to be given for the null value attribute for this column?

Maveric · Post by **Maveric** » Tue Dec 04, 2007 12:50 am

The value should be of 3 character long. 3 spaces will do. But just curious how are you planning to store a date in 3 characters. it would require a length of 10.

ds · Post by ds » Tue Dec 04, 2007 12:59 am

Ya.. Its of length 10 only..
Whether we have to give spaces in single quote or double quote.. IS there any other way

kunal1101 · Post by **kunal1101** » Tue Dec 04, 2007 1:07 am

One option can be changing properties on metadata page.To do this you can right click the concerned column,go to 'edit row',ther you can specify Actual field length, Null field length, and Null field value for that column.