How to use scripting component as transformation in SSIS
I want to perform some operations for each record from the source and then do some operations in scripting component. I also want to catch the error and save the error in a log table and if no error then insert record in destination table.
Is there any tutorial on this? I need a starting point though, I assume there would be some sort of variables i would need to use?