I have an opinion question. I have a sort of round-robin sets of pulls and updates. I'm wondering viewpoints on how others might tackle this when using SSIS.
1. Receive an email with a CSV attached from system A.
2. Take CSV from system A and do inserts/updates on system B
3. Take an extract from system B and perform updates to system C.
4. Take an extract from system C and perform updates to system B and system D.
Nice and abstract huh? Anyway, number 1 I'm doing as a stand alone package because I might also get emails with attachments from other sources.
I'm thinking to also have numbers 2,3, and 4 as individual packasge because that keeps them as logically separate packages that could be tweaked independently and that could even run on widely different schedules.
I may not be giving enough information but does anyone have any thoughts?