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 |
|
ndindi22
Starting Member
14 Posts |
 Posted - 2007-11-05 : 04:09:01
|
| Hi guys I need help, I am building an Intranet for my company, and we have a system here that we use to clock in and clock out, and the data is stored in an Access database. Now the HR manager needs to run a report weekly for all the temps to see what time they clocked in and out. I have designed a web form where he puts in the date from and date to and select the employee, BUT the problem is I'm using SQL Server, I import the Access database to SQL every morning. Now I need to know How can I have Job in SQL that will import the data automatically without me having to do it manually every morning.How do I do this using SSIS and DTS I'm using SQL Server 2005.Thanx guys, plz helpndindi22 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-11-05 : 10:13:41
|
| Why don't you keep the data in the access and serve them up to the intranet? Since you only have limited users in the app for the report, intranet is only needed if the user are located somewhere else. Access report itself is easier and rich.Back to your question, to use SSIS,1) develop a SSIS package in SQL Server Business Inteligence development studio,2) deploy it to server 05 server, and, 3) use sql agent to schedule a job for daily import. |
 |
|
|
|
|
|
Importing Access to SQL using SSIS/DTS