import txt from http

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Rob Wahmann
    #1

    import txt from http

    Is there a quick way to import a txt file from an http location manually...
    and then later automate the process? This is a do-not-call list that
    consists only of phone numbers. I appreciate any and all pointers!!!

    TIA - Rob


    Tags: None
    • DMAC
      #2
      Re: import txt from http

      "Rob Wahmann" <rob@wahmann.co m> wrote in message news:<brHDb.126 31$aw2.6740611@ newssrv26.news. prodigy.com>...[color=blue]
      > Is there a quick way to import a txt file from an http location manually...
      > and then later automate the process? This is a do-not-call list that
      > consists only of phone numbers. I appreciate any and all pointers!!!
      >
      > TIA - Rob[/color]


      ftp may be a better protocol , especially as the whole process
      -ConnectToSite-DownloadFile-ImportToDestina tionTable can be easily
      automated as part of a scheduled job which calls a DTS package which
      has all the relevant details. Think the ftsTask is new to SQL Server
      2000

        Comment

        • Rob Wahmann
          #3
          Re: import txt from http

          Thanks for the reply. I don't have control of the download format... I'll
          see what I can come up with based on your suggestions.

          Rob

          "DMAC" <drmcl@drmcl.fr ee-online.co.uk> wrote in message
          news:462ac9a0.0 312161557.44dc0 aed@posting.goo gle.com...[color=blue]
          > "Rob Wahmann" <rob@wahmann.co m> wrote in message[/color]
          news:<brHDb.126 31$aw2.6740611@ newssrv26.news. prodigy.com>...[color=blue][color=green]
          > > Is there a quick way to import a txt file from an http location[/color][/color]
          manually...[color=blue][color=green]
          > > and then later automate the process? This is a do-not-call list that
          > > consists only of phone numbers. I appreciate any and all pointers!!!
          > >
          > > TIA - Rob[/color]
          >
          >
          > ftp may be a better protocol , especially as the whole process
          > -ConnectToSite-DownloadFile-ImportToDestina tionTable can be easily
          > automated as part of a scheduled job which calls a DTS package which
          > has all the relevant details. Think the ftsTask is new to SQL Server
          > 2000[/color]


            Comment

            Previous template Next
            Working...