Question About Data Transformation Services : How To Define Myself's Query Without DTS Wizard?

hi there, I have never use DTS before, now I am reading textbook for some special demand with DTS

the textbook not talk very much for the detail of skills. seems the easy way to finish this query is using DTS wizard.

but my requirement seems can't be done by DTS wizard.

 here are my requirement below.

 [move online Database to offline Database ]

1.  the time of  data preserve will have to reference separate firm's history data backup time  ( for example, A company used to preserve data 6 months, and B company used to preserve data 12 months and so on..)

2. we will have only 2 kind of preserve time  one is 6 months another is 12 months

3. The online DB only keeps 6 months data ( for example, when we do the DTS on 11/1 , we will only keep the data which from 5/1~10/31) , all data have to move to off-line DB except the past 6 months data

4. We will have to reference the history data preserve time to delete data after finished data movement

those requirement looks very diffcult for me  because I have never use DTS before , can you please give me a simple example or maybe some article I can reference?

 

thank you very much and have a nice day