Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2012-10-31 : 05:57:27
|
| Dear allwe Fetching the Data from Oracle to Sqlserver using ssis packages throug Sql Agent job.tables are having huge amount of data.user have to see the reports data of Current month(october) and previous month(sepetmember) data.not required before 2 months data. Every month we are doing take the backup of data of that month and deleting the data manually on that specified Transcation Table(delete from tablename where date <'01-sep-2012').we want make this process as AUTOMATION Using Sql Agent job(Scheduler.) that means in november month october and novmonth data onlyin december month november and december only.how to make this process dyamic.thanks |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2012-10-31 : 15:32:40
|
| There are lots of ways to do this. You could set up a SQL Agent job that runs on the first of the month (or whatever makes sense) that does the delete from each table or calles a stored procedure or calles an SSIS package. Another option is to have the current SSIS packages you already have handle deleteing the old data before/after it loads the current data.. etc.. |
 |
|
|
|
|
|
Dynamic Archiving process on Sql sever table