Hi - I am SUPER new to SSIS , kind of thrown into it with no training or help other that what I can dig up on Google - so I am hoping one of you can walk me thru this.
I have a multi-tabbed Excel file as input - where tab 1 has
action ---- reasonID ---- description
New ---- 1 ---- add new record
Update ---- 2 ---- chg descr of record 2
Delete ---- 3 ---- remove record 3 entirely
I figured out how to create a Conditional split based on the action. and to create a Recordset of the result ( I think)
my problem is - I now have 3 output record sets in my data flow tab.
When I am back in the Control flow -- how do I update the ExceptionReason table with the data from each reason set? besides each one having different recordset names, they will need to perform a different set of SQL ( Insert, Update or Delete)