How to Importing Access to SQL Server 2005 using SSIS and DTS - Integration Services (SSIS) and DTS

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Integration Services (SSIS) and DTS » How to Importing Access to SQL Server 2005 using SSIS and DTS

How to Importing Access to SQL Server 2005 using SSIS and DTS

Options

Previous Topic · Next Topic

ndindi22

Posted: Monday, November 05, 2007 3:20:53 AM

Rank: Newbie

Joined: 11/5/2007
Posts: 2
Points: 6
Location: South Africa

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.

I'm using SQL Server 2005 and I guess I have to use SSIS and DTS. How do I work with SSIS and DTS

Thanx guys, plz help

Scott Whigham

Posted: Tuesday, November 06, 2007 1:58:24 PM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

You mean SSIS, right? (since you're using SQL 2000)

Seems like an easy thing to do - if you understand SSIS. If you don't understand SSIS, I'd definitely recommend some SQL Server integration services training. I think what I will do is create some videos on how to migrate access on the SSIS training site (http://www.learnintegrationservices.com).

What you need to know is (1) how data flow works in ssis, and (2) how to schedule an SSIS package as a SQL Server job.

http://www.learnintegrationservices.com/VideoTutorials/SSIS-Tutorials/197/Series-3-videos-How-to-Schedule-An-SSIS-Package-To-Run.aspx

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.