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 |
|
Diana_j86
Starting Member
1 Post |
 Posted - 2008-06-07 : 03:55:16
|
Hello,I want to ask if there is any option in SQL Server 2000 that can be used to import automatically every day....I have an FoxPro database which is updated every day and I want my main table in SQL Sever to be updated by importing every thing again from the FOXPRO ever day at night.....is there any option for that?Thanks, Diana |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-07 : 04:04:27
|
| Yup. You can create a DTS package that imports the data from Foxpro table. You could also create a job which calls this DTS package and executes it and schedule this job so that it executes everyday at a convienient time for you. |
 |
|
|
|
|
|
importing automatically from another DBMS