Auto importing

Results 1 to 2 of 2

Thread: Auto importing

  1. #1
    Join Date
    Dec 1969

    Default Auto importing

    I have a client that sends me all their information in a text file on a weekly basis. I then import it into SQL after I receive it. It is a tab delimited file and imports very easily. Is there anyway I can automate this task? Can I tell SQL to grab the text file and import it every Wednesday night?

  2. #2
    Join Date
    Dec 1969

    Default RE: Auto importing

    Yes sir, you may.<BR><BR>Look into "Scheduling DTS Packages"<BR><BR>You can go into sql server v7.0 or higher, and create a dts package, tell the data from the text file where to go, then schedule it to run whenever you want.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts