Ah... another avenue is to google for "ebcdic to ascii converter".  Some are converters you have to pay for but the following link provides some hope for a free method. ...

@Thom A

I dunno, Thom... I won't help the fellow you just helped (the one with the Blue shirt) because...

Nah.... do what I do... don't even bother SSIS for this.

I created files for your two sample tables being sure that the first one's lines was terminated with LF only and the...

Sorry... I don't have a "test dtsx package", Rocky.  I would have done all of this using BULK INSERT all from a stored procedure including reading the file names.  I...

If the answer to the last question above is "Yes... I already have these all mapped out in SSIS", there no need to throw all that work away.  Just make...

One more piece of info, please.... do this files have the exact same fields in exactly the same order but are simply different in field width?  And both are supposed...

Have you looked as the stored procedures to see if there's a BEGIN TRAN anywhere?

What other help with that query do you actually need?  Folks there have answered correctly.  The LIVE table is used twice... once for employees as an alias of "e" and...