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?
How to send a binary zero to mainframe system?
Previous topic • Next topic • 3 posts
• Page 1 of 1
How to send a binary zero to mainframe system?
by Yash » Fri Jan 16, 2009 10:26 pm
- Yash
- Posts: 1
- Joined: Fri Jan 16, 2009 10:21 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: How to send a binary zero to mainframe system?
by Bill Dennis » Fri Jan 16, 2009 11:05 pm
Are you expecting ASCII to EBCDIC conversion on the character fields so FTP as BINARY is not an option?
Regards,
Bill Dennis
Disclaimer: My comments on this forum are my own and do not represent the opinions or suggestions of any other person or business entity.
Bill Dennis
Disclaimer: My comments on this forum are my own and do not represent the opinions or suggestions of any other person or business entity.
- Bill Dennis
- Posts: 278
- Joined: Thu May 15, 2008 9:45 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: How to send a binary zero to mainframe system?
by dick scherrer » Sat Jan 17, 2009 2:35 am
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?
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?
Hope this helps,
d.sch.
d.sch.
-
dick scherrer - Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Previous topic • Next topic • 3 posts
• Page 1 of 1