I have a simple txt file which has header row, detail rows and trailer row. I defined 3 different flat file managers (actually, I used existing package, but completely re-defined the connection managers). I defined my columns correctly according to the specs. All columns are manually set up to the widths defined in the supporting Word document. I set file format as fixed width and delimited with CRLF.
When I preview first 5 rows, it looks incorrect :( I cannot figure out what is wrong, all columns are defined as DT_STR with correct lengths. The original file used ragged right as the file type, but in my case the columns are fixed - why it's not working?
One more question - is there a 'CONTAINS' or similar function to check for 3 predefined types? Right now I'm using this expression in the conditional split - is there a way to simplify it?
record_type_cd != "10" && record_type_cd != "20" && record_type_cd != "90"