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 - 2013-05-17 : 03:59:42
|
| Dear teami am loading the data(tables) from source(Oracle) to destionation(Sql server(2008))using SSIS packges.In Few tables having huge amount of data(transcationaldata).so my destination Specified Duration(example month or 3 months wise)data move to another table on same or different database for My Reporting Pupose. whenever i need this data i will fire the query on this table. right now i am doing this process manually on every month.I need to do the Archiving Process (using SQL Schduler jobs )anybody know explain me way? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-17 : 04:03:06
|
| you can create a procedure which will archive the required data from tables to your destination database tables based on timeperiod (3 months, 6 months etc). Then add a sql agent job in sql server agent to call and execute these procedures. Then set a schedule for the jobs to make them execute automatically as per the set frequency------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2013-05-17 : 05:41:45
|
| Hi,thx for your Suggestion.pls Share the Stored procedure for futher Process . if any modifications Required pls inform |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-17 : 06:07:45
|
quote:
Originally posted by kond.mohan
Hi,thx for your Suggestion.pls Share the Stored procedure for futher Process . if any modifications Required pls inform
SHare the stored procedure?How will I know what are your objects, frequency etc?I just gave you suggestion. You may come up with one that fits with your requirement.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Archiving Process Automaiton in SSMS2008