Sorry for the delay and for the long post below.

If any one has any comments/questions/suggestions all are welcome.

I've decided to have a go at processing this...

I do prefer convert due to the extra functionality over cast. And from a standard point of view I think its better to stick with a single format type unless...

Looks like you are having fun:D

I do have a comment - avoid FORMAT if the same formatting can be achieved with convert - check https://sqlperformance.com/2015/06/t-sql-queries/format-is-nice-and-all-but

Just a quick note to say this is not forgotten - just complex and with other things to do at the moment.
Part of the work done though.

@jeff...

tell them you need to load this to a SQL Server database - they should already have had that request many times, and its easy enough for them to do...

Hi,

Had a look at the file and its going to be a bit more complex as it has multiple record types on it.

I may be able...

File is indeed ebcdic - but as it contains COBOL packed fields you will need to convert those independently within SSIS before loading to the database.

Have a look...

Not fair!!! I feel deceived!!! 
was hopping for a healthy discussion on the benefits of good coding and database design!!!

Regardless of what is causing the issue have you considered not updating the table, but rather do the insert into a new table where you add the column on the...