December 22, 2006 at 12:04 am
hi,
I have 10 tables in ms access.
currently what i am doing is ...
1) import data into ms sql server, hence creating 10 tables
2) i have 2 procedures which does some calculations (basically consolidation of data) based on 10 tables. And insert data or update data into 2 tables.
Can i automate this etl process..
take data from 10 ms access tables
consolidate and put the data into 2 ms sql server 2000
I want this process to occur every weekends
Please guide if any body has done this kind of process
December 22, 2006 at 12:38 am
For all the steps you explained create a SSIS package and Schedule it as sql job to run as you needed....
MohammedU
Microsoft SQL Server MVP
December 22, 2006 at 3:42 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply