I have been searching a simple downloadable sample from the web. Guess what… I cannot get one after searching for 2 nights.
I decide to come out with a simple sample by reading some sites. Finally I got something that can work.
· Put a Script Component in between Source and Destination database’s table
· Add Output Columns
· Edit script