Can you give some example of what you are trying to do? Table ddl would be nice.
SSIS has the import column transformation, it may be worth checking that one out.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP