Bug in Derived Column??

[williey]

Source file is fixed length being passed into derived column task and finally going into destination table.

There is a column A which are blank for certain rows. When a blank column A undergoes derived column task, the resulting derived column B has the value of the previous row's value.

Add the data viewer to the flow to confirm. True enough, derived column task does not initialized the fields before processing the next row.

------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.

 

[MDXer]

derived column task won't acomplish this, you need to write a custom script task to accomplish this.