couple options off the top of my head.
1) you could do exactly as you mentioned and create a variable/output port and correct the bad data before loading.
2) at the session you can configure the mapping to not stop on errors so the good bad is loaded and the bad records reject. you could write the bad records to a file or database.
Sorry - what I meant to ask is, how do you ignore these errors and load the other data values/columns in the row? Ignore the div/0 - right now, it is slipping those rows.
I wrote an IIF statement and it fixed the issues - thanks for the replies.