Yeah, I understand, ... but ...  what's the alternative?   If you have specific columns that you know the starting x number of characters for the column name, dynamic SQL is probably the ONLY way to have automation handle things.   Also, you might be able to use a Script Task within SSIS and use ADO code with VB or C# to maybe make the code more specific than doing it all in T-SQL, but no matter how you slice it, something will have to be dynamic.

I've seen Lynn's post about using the sys.tables or sys.views or sys.columns type of metadata info instead of INFORMATION_SCHEMA, and for some things, those are more practical, but if you just need to identify column names for some dynamic SQL ...