Hi guys,
i am new in SSIS and stuck with one functionality.
Let me explain exact scenario.
I have more than one stored procedures and all procedures have single select statement (ofcourse all procedures returning differnt different columns).
I want to use something like "for each loop container", which will execute one procedure, get result data and create excel file for those data. Then again same process for next procedure. But here mapping of procedure result and excel destination having an issue.
I thought, this might be a common scenario, so someone already done this, but didn't found any interesting while googled.
Please let me know with more details as i am a beginner in SSIS.
Submit an article or tip