Binary numeric field in a MVS flat file

• Victor YAMMOUNI

  SSC Rookie

  Points: 47

  More actions

  May 4, 2006 at 8:53 am

  #117422

  Hello

  I need to read a flat file comming from a MVS Host. It contains an EBCDIC text (this is not a problem) and a binary numeric fields (that is the problem).

  I use to read it with SAS Language and it works fine because this language has a huge kinds of format specially to read flat files comming from any system.

  Is any way in SSIS to read this kind of files????

  Thanks

• alex0603

  Valued Member

  Points: 59

  More actions

  September 29, 2006 at 12:22 pm

  #663425

  In advanced editor / Input and Output properties tab

  change the useBinaryFormat property to true for the columns

  that are numeric (This is only available on SP1 +) in the output columns branch