Skip to content


Running map from SQL

Mike Tsui asked 2 years ago
Is there a way to run the SC mapping from SQL task ?
Also possible to group mapping, ie Map 1 – import form text, Map 2 – import from SQL to GP
If map 1 fails, do not run map 2 ?
Patrick Roth Staff answered 2 years ago
1. this old blog article talks about how to do exactly this
2. you get that by default unless you are doing something odd
map1 executes and it is either a “map failed” or “map success”
so in your case, you’d make a ‘map success’ event to do a “run map” task on the first map which then would run the second map.
since if the map fails the ‘map fail’ event runs and there would no run map task, the second map never gets executed
Mike Tsui replied 2 years ago

That is awesome, thank you so much

If you would like to submit an answer or comment, please sign in to the eOne portal.