this question on how structure ssis package solve specific problem (i'm new ssis , have not found on correct approach).
my problem: have ssis package reads simple xml file. xml source sees information single table. 1 of table columns qualifier affects way record processed. rather having processing of qualifiers in single task, i’d have separate task each qualifier (for modularity). have task each qualifier read, shred, , process xml file, reading , shredding xml file multiple times seems inefficient way of doing this. i’d think better have task xml source persists data, , have data used number of other tasks process data.
a possible solution: i’ve read, correct approach save data raw file destination, , have various tasks use raw file source. seems global variable me. there better way? can figure out specifics, don’t need detailed answer, best approach.
thanks
i use ssis conditional split transformation this. can evaluate "qualifier" column , send specified instances down different paths within data flow task.
