Import EBCDIC file to SQL Server

Question

I have a file (10 gigs) in an export from a Mainframe database in EBCDIC format. I am trying to get this into a SQL Server 2008 database to query for a client. I am 100% clueless about conversion or import of this format. Repeated Google searches have not yielded any usable results. Any help would be appreciated. I do have a schema document that came with the export. The vendor is no help though. At this point I am willing to just pay someone for conversion if needed.

Do you have packed decimal data (comp-3) in it or is it just an EBCDIC to ASCII conversion? — billinkc, Jun 02 '11 at 17:43

score 3 · Answer 1 · edited May 23 '17 at 11:48

3

See my answer at Reading a Cobol generated file. It may help figure it out.

edited May 23 '17 at 11:48

Community

1
1

answered Jun 02 '11 at 17:57

Nicholas Carey

71,308
16
93
135

Your answer gave me a headache but thanks. I'm glad I never had to learn that! – Brian Spencer Jun 02 '11 at 18:45

score 0 · Answer 2 · answered Aug 20 '11 at 07:33

0

Amino Software makes a component to solve this exact problem, called Lysine.

http://aminosoftware.com

answered Aug 20 '11 at 07:33

Patrick Altman

890
8
10

Thanks I am taking a look. Have you used it? – Brian Spencer Aug 22 '11 at 15:05

Import EBCDIC file to SQL Server

2 Answers2