Yeah, I'm kinda confused too.

So you have an inbound column of datatype Char(1) or something character based? And you want to derive a new column from that which will be of type BIT? First I don't think you can have a null BIT value.. but I could be wrong on that, I dunno why one would want a null BIT...

In any event, this message and forum isn't the right place for your question.

Start a new thread, include in the subject something about "SSIS Expression Language".

Your question will get more attention that way.

Post a link to it in this thread. I'll poke around w/ your idea and if I come up w/ something I'll respond to your new post. No promises.