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 |
|
j3474
Starting Member
2 Posts |
 Posted - 2002-09-24 : 10:19:32
|
| Hi evryone, I got a question regarding importing data using Jobs. I am trying to import data from FOXPRO (dbf) tables in to sql server and I need to do this import everyday. I am trying to create a new Job in Sql Server Agent. In the STEPS part of the Job i created a new step, give a step name and select the type as Operating System Command. But i dont know what to write in the COMMAND part of the step. i mean i dont know the exact syntax that i need to put in here. for example imagine i am trying to import data from data1.dbf(foxpro) in to a sql server table DATA1. what do i put in this command part of step? or How do i do it.May be a dumb question but i would really appreciate if someone can help me with this.Thanks a lot for ur time.-Jay |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-09-24 : 10:35:02
|
| Hi Jay!You need to choose a way to import the data from the foxpro database into the SQL server. For example, you could use a DTS package or a linked server. I would advice you to look at the import/export wizard (Enterprise manager -> tools menu -> data transformation services -> import data). Before you do this, install a foxpro ODBC driver if you haven't got one.If you run through this wizard you will get the option to schedule the import automatically.Edited by - andraax on 09/24/2002 10:35:28 |
 |
|
|
j3474
Starting Member
2 Posts |
Posted - 2002-09-24 : 11:16:55
|
quote:
Hi Jay!You need to choose a way to import the data from the foxpro database into the SQL server. For example, you could use a DTS package or a linked server. I would advice you to look at the import/export wizard (Enterprise manager -> tools menu -> data transformation services -> import data). Before you do this, install a foxpro ODBC driver if you haven't got one.If you run through this wizard you will get the option to schedule the import automatically.Edited by - andraax on 09/24/2002 10:35:28
Thanks a lot andraax. ur genius. i have been thru this importing and exporting good number of times but never concentrated on the options. from now i will.thanks for ur time.-jay |
|
|
|
|
|
|
Creating a new job to import data from foxpro