Yes very true......
This seems to be a like a very simple mapping. Just create a DataFlow task. Define a source and a destination and have a derived col transform in between. On the dest connection, map based on the specs you have in the old DTS package.