Ali Shah
asked on
How to use scripting component as transformation in SSIS
Hi Guys,
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?
regards
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?
regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Regards,
Ali