SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Archiving Process Automaiton in SSMS2008
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kond.mohan
Posting Yak Master

India
196 Posts

Posted - 05/17/2013 :  03:59:42  Show Profile  Reply with Quote
Dear team
i 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

India
52325 Posts

Posted - 05/17/2013 :  04:03:06  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

kond.mohan
Posting Yak Master

India
196 Posts

Posted - 05/17/2013 :  05:41:45  Show Profile  Reply with Quote
Hi,
thx for your Suggestion.
pls Share the Stored procedure for futher Process . if any modifications Required pls inform
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 05/17/2013 :  06:07:45  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000