So what we are looking at is a rolling delete process
My preference (for codeability) would be a sproc in the database that takes two arguments Tablename to be deleted and Days to Keep
The sproc would build a dynamic SQL statement to remove the records
NOTE the code below has not been checked, it is symantec rather than syntactic.
CREATE PROCEDURE dbo.uspDeleteOldData (@TableName nvarchar(50), @DaysToKeep int default = 90)
DECLARE @SQL as nvarchar(max)
SET @SQL = N'DELETE FROM ' + @TableName + ' WHERE CreateDate <= ''' + cast(DateAdd(days,(@DaysToKeep * -1), getdate()) as nvarchar)
I would then build an SSIS package that simply has a list of SQL tasks that calls the sproc for each table you need to clean up.
NOTE that you may end up with lots of sparsely populated index pages so you will need to clean up the database on a regular basis to remove the unused space.