April 23, 2012 at 3:42 am
What should be the code page for Flat file connection manger in SSIS for it to be consumed by Mainframes system..
I am currently using Unicode, ragged right format. when mainframes read it, there NULLS inserted between each character.
April 23, 2012 at 3:55 am
Try using 1252 codepage, which is the default.
In order to do that, you can't use Unicode anymore.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 23, 2012 at 3:59 am
Yes Koen.. I will use 1252 instead of Unicode.
just curious to know, if there is any specific code page related to mainframes..
April 23, 2012 at 4:01 am
Gerbera (4/23/2012)
Yes Koen.. I will use 1252 instead of Unicode.just curious to know, if there is any specific code page related to mainframes..
No idea. I don't know a lot about mainframes and I like to keep it that way.
I do know they may have other row delimeters than Windows, for example only CR instead of CR/LF.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 23, 2012 at 11:53 am
All the mainframes I have dealt with use some form of EBCDIC...but "EBCDIC" is about as ambiguous as "Unicode". If you're providing data to a mainframe you'll need to ask the operator for specs on exactly which code page to use.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2012 at 11:27 pm
i used this code page 437 – OEM United States and it solved the Issue.
But when tried with 37 IBM EBCIDIC US/Canada and 500 IBM EBCIDIC International code page, the file was genarated was corrupted
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply