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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-10 : 08:03:09
|
| Oliver writes "Hello, Dear SQL-Team!Is it possibe to schedule (time) the import of ASCII and CSV-Data with SQL 7.0? If it is, what would be the easiest and best way?Thank you very much indeed,Oliver" |
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2003-02-10 : 10:22:14
|
| I have done this a few times...not alot...but we used DTS to accomplish this. Defined an import job in the dts designer and then scheduled it on a recurring basis. |
 |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2003-02-10 : 10:37:24
|
| In addition to the reply from dhw, if your import is already writting in Transact SQL, you can schedule it to run as a job through SQL Server Agent. Especially if you need to utilize the speed that using BCP and/or BULK INSERTs can provide over DTS. |
|
|
|
|
|
|
scheduling import