Fairly new to ssis and not sure if this is possible, I believe it isn't.
I want to export 100 queries results from server to flat csv files .
Currently I'm thinking I need to have 100 data flow tasks as each query has a differing column configuration .
Am I right in thinking this can't be done in a loop even with dynamic sql as the meta data mapping needs to be explicitly mapped?
I want to export 100 queries results from server to flat csv files .
Currently I'm thinking I need to have 100 data flow tasks as each query has a differing column configuration .
Am I right in thinking this can't be done in a loop even with dynamic sql as the meta data mapping needs to be explicitly mapped?