0

I have a EBCDIC (Mainframe) VSAM file without any carriage return. It is like a million characters long. With SSIS, could I loop on the file's single line and add a carriage return each time I hit the SIN of the first record type? (record control type starts with 90)

I have not found any doc on this particular function or if it is possible at all.

user6854154
  • 67
  • 1
  • 1
  • 4

1 Answers1

1

I'm not familiar with VSAM or what the SIN token is but you should be able to use a normal flatfile connection but change the new line identifier from carriage return to the SIN. The default end of line token is "{CR}{LF}"

The flat file connection would then treat the SIN's as carriage returns and align your file accordingly

Here is my "VSAM" file with SIN as the carriage return token

VSAM

Create a flatfile source and set the column header row delimiter token to SIN

Connection

Next set the row delimiter to SIN

RowDelimiter

Hit refresh columns to align everything

All done

Ockert
  • 425
  • 4
  • 6