The only option you have in defining an SSIS variable is BYTE as a Binary data type. this isn't a transformation data type problem.  Its using the SSIS variable to...

The data already is the problem appears to be that that's not a type option for SSIS variables  only BYTE

What version of SSMS are you using?

I've seen this when you try to connect with a version of SSMS that is a higher version than 2014

I think this is an...

Auto - save ? where?  SMS or Direct access

Update fixed

This is an ETL to a datamart, so there is no Write activity on the destination other than the ETL This is a Change Data Capture using the SSIS objects ...

Additional info:

If I upgrade the project version to SQL 2016 then it works
However, I can't do that because My server(s) are 2014 and can't be upgraded until a current huge...

The reason it is written the way it is, is that the underling data may change between page changes on the mobile devices that this was written for. Hence not...