August 30, 2008 at 8:02 pm
Hi:
Currently I used sql 2005 report service to design the report. The purpose is I have to import some data in tables from Access database. In the beginning, In sql 2005 management studio, I just right click database -> task -> import data. Then it shows import/export window. Then I choose source from microsoft access file and give to source file location. Finally, i choose write the query, it like: " select * from customer". then the customer table and data is created and copied in sql server 2005.
MY question is customer table in Access is updated everyday. I have to pull out the new rows to my customer table in sql server 2005 too. How can i do that. Can i schedule to automatically update the table everyday?
Thank you
August 30, 2008 at 9:21 pm
I am not sure how you are doing this update process now, but if it were me, I would setup an SSIS package to do the data migration, and then create a job in SQL Server 2005 to run that package at a specific time each day.
Hope that help.
August 30, 2008 at 10:15 pm
Thank you. So how can schedule the pacjage on everyday ? Through Sql Agent?
August 30, 2008 at 10:53 pm
Hi,
When you open the package, there is an option to schedule it. Below the options to choose a name, description; the schedule can also be configured which creates a job with that specified schedule.
[font="Verdana"]Renuka__[/font]
August 31, 2008 at 10:36 am
Renuka is correct, although I didn't know it when I wrote the last message.
To setup a Job in SQL Server, you need to expand the Management folder in SQL Server. Jobs will be one of the items listed under that folder. Just right click on Jobs to create a new one.
Fraggle
September 1, 2008 at 3:43 am
hero1971 (8/30/2008)
Hi:Currently I used sql 2005 report service to design the report. The purpose is I have to import some data in tables from Access database. In the beginning, In sql 2005 management studio, I just right click database -> task -> import data. Then it shows import/export window. Then I choose source from microsoft access file and give to source file location. Finally, i choose write the query, it like: " select * from customer". then the customer table and data is created and copied in sql server 2005.
MY question is customer table in Access is updated everyday. I have to pull out the new rows to my customer table in sql server 2005 too. How can i do that. Can i schedule to automatically update the table everyday?
Thank you
Hi this is prahsant
Plz try the same using the DTS package
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply