Export To A Text File, Then Name The Exported File The Date Is Was Exported, Then Zip

Hi folks



Any help on my request would greatly be appreciated. We are trying to maintain the growth of a particular table, by exporting and deleting data that is older then 90 days. Here are the 4 steps I need to do. I believe I know how to do 1 and 4;

1. Create a job that continously exports data that is older then 90 days to a text file

select *

from table A

WHERE (CREATED < DATEADD(DAY, - 90, GETDATE()))



(the column 'created' datatype is datetime and looks like this '3/5/2007 3:11:44 PM')



2. Have the job automatically name the exported file, the day it was exported (i.e. 07032007 (todays date))

3. Then zip that file (we're using 7-zip)

4. Then delete the data out of the table

delete

from table A

WHERE (CREATED < DATEADD(DAY, - 90, GETDATE()))



Im not a big scripter/coder, so I was wondering if there is anything I could do in SSIS. Im more familiar with DTS, so any kind of baby steps you could provide in SSIS, would go a long way.



Thank you so much.