hi,anybody
 I want to import and convert from log file to sql server7 but my problem are
1.i have many file which separate by date
2.i want to make it import automatically by i just set time interval
i really want to know if it possible to import theses file by use just sql server config and use time scheduling..
  thanks everybody

  What format is the data that you want to import? Text?

You can create a job and schedule it at the intervals that you desire. This job can run a DTS package for you.

Could you please elaborate on this?





Sal

the file that i want to import is text file.I collect data(log file) that's automatically created everymin from another server to my computer.there are many files i need to import to sql server seperated by date.And, i have to import those data in files every 15 min at least.I want to use sql config to config this problem...is it possible?

ok, just create a DTS package. You can create a conection to the textfile in the designer. Once you complete the package, you can seve it and schedule it. I think someone already asked that question earlier (about 3 weeks ago). Do a search on this forum for text under the dts forum. There are some instructions on how to get it done.

If the file is always saved with the same name, you can import the complete file. The only question is, Is this file beein appended or completly re-created? that determines how you import tye data.




Sal