We have approx. 4000 decimal and char type columns in a Sequential writer. All the columns are Nullable. I need to define the "Null Field Value" for each column thru Edit Column Meta Data. Most of the char columns are more than 20 bytes long. Is there is shortest way to put the spaces rather than pressing space bar equal to the length of the column. I saw in one of the post to put 19 "*" that means replicate 19 times spaces. It is treating like a literal when I used the same expression.
Please help me out on this.
Null default value
Moderators: chulett, rschirm, roy
Null default value
nynali
you can probably change the data type to Varchar for all the fields and specify Null field value property in Field defaults under Format tab to \1. And don't specify any length to the fields. Can change the first field value to Varchar and delete the length and propagate that to all the other fields. Not sure if this will work. Try it in a dummy job first.