We are obviously missing something or you've left out some critical details - this is dead simple and should work as desired and as (allegedly) designed... unless you are not telling us everything.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Again, for the umpteenth time, your design as postedwill do exactly that. What are we missing?
What exact 8.x version are you running, btw? If it is anything other than the latest iteration of 8.1.x.x then suggest you check with your official support provider and see if this is a known bug in your platform's version.
-craig
"You can never have too many knives" -- Logan Nine Fingers
kris007 wrote:
Unless you specify a default for NullFieldValues within the Sequential file stage properties you will have trouble reading NULL's.
I don't think so, if the field is set as Nullable = Yes, the NULL will be stored with nothing separated by the field delimiter (,) with the default setting something like
"ABC",,90.00
Certainly you can read the same out from sequential file with same default setting