I have a ssis package built with 100s of Data flow tasks. Each of the dataflow tasks contains a derived column task and that has a column with a value "question". Derived column task has placed it in unicode format automatically. After building
all the package I have realized that and now want to cast the column in str format. I dont want to go to each and every derived column task and cast it. Is there any way I can do it in easier way, like replacing a value in the code of the package ?
View Complete Post