Thanks for the quick reply!

Actually I have progressed slightly from before!

This is the process I am following, where I am selecting data from a source and adding a number...

I seem to able to load the data but i get a primary key violation error in the destination database. I used a lookup transformation to lookup the dimension tables...