November 5, 2007 at 1:53 am
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.
Thanx guys, plz help
November 5, 2007 at 2:46 am
1. Create a SSIS/DTS Package
2. Schedule the package
--Ramesh
November 5, 2007 at 3:14 am
Sorry Ramesh,
How do I Create a SSIS/DTS Package and where?
November 5, 2007 at 3:28 am
which ver. of SQL Server using ?
SQL Server 2000: You can create DTS package through Enterprise Manager.
SQL Server 2005: Use Business Intelligent to create SSIS package.
November 5, 2007 at 5:04 am
Thanx Ramesh for replying,
I'm Using SQl Server 2005 and I've never worked with SSIS and DTS, plz tell me how do I start where. I need to import the table automatically every morning.
Plz help
November 5, 2007 at 5:15 am
If you have installed SQL Server 2005 completely (i.e. means includes samples), you can go to the samples folder and check the existing samples, so that you get some idea to create SSIS packages.
check the folder: ( :\Program Files\Microsoft SQL Server\90\Samples\Integration Services)
More Information see the SQL Server 2005 BOL
🙂
November 5, 2007 at 6:23 am
Hi Kishore.P
Thanx man, I noticed that I don't have Samples under MSSQL/90. I went to BOL but they not helping me either, I sound stupid but I never thought this could be so complicated, I've search and googled, post forums but I can't get an answer, you guys are my only hope atleast you giving me ideas.
November 5, 2007 at 7:48 am
Kevin -
Have you considered simply moving the tables into SQL Server, and modifying the Access front-end to smiply link to those tables? Would be the best of both worlds, and there would be no need for any import/export/schedule.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply