DSXchange

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?

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.

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

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.