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 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?
.
social.technet.microsoft.com/Forums
No comments:
Post a Comment