SSIS - ASCII to EBCDIC - Packed Decimal Fields

[RajSinghDhanjal]

Good Day All,

I am facing a challange to create a output file in EBCDIC using SSIS.

The data source is Sql Server

The output field structure is like following:

Field Names ¦ Source Data - SQL ¦ Target-EBCDIC
---------------------------------------------------
Field 1 ¦ varchar(50) ¦ Char(50)
Field 2 ¦ Decimal ¦ Packed Decimal
Field 3 ¦ Varchar(20) ¦ Char(20)
Field 4 ¦ Int32 ¦ Packed Decimal
Field 5 ¦ varchar(10) ¦ Char(10)
Field 6 ¦ Int32 ¦ Integer

Any quick tips/comments/code on how to create the following above output format in EBCDIC will be highly appreciated.
Thanks a lot for your help in advance.

Thanks,

Raj

 

[philhege]

From some quick research, it appears you can write a script component to do the translation. Google "ASCII to EBCDIC"; there are a number of examples (Java mostly, but you'll get the idea).

-----------
With business clients like mine, you'd be better off herding cats.