IBM Mainframe Forum

Hi Guys,
I need to send a flat file to a mainframe system that has a field in the following format:

Filler PICX(3) value=binary zero

Can someone tell me how can I send a binary zero in to this flat file from my SSIS package?

Are you expecting ASCII to EBCDIC conversion on the character fields so FTP as BINARY is not an option?

Hello and welcome to the forum,

If the only binary number you need to work with is x'000000' you don't need to worry about translation - x'00' is the same in ascii and ebcdic.

What does the sql code in the ssis package look like?