Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SQL Server DTS/FTP (SQL Serv2000)

    I have set up a DTS package that will go to my HD and upload files that I previously retrieved via FTP. Is there a way to get DTS to login and download from the FTP site directly? (I may not actually do this as I feel compelled to check the files before dumping them to SQL Server but a basic answer will be good to know for future projects -- or for the one I am involved in, if we can get people to setup their datasources correctly.) <img src=/S/blackteeth.gif border=0 alt=blackteeth width=20 height=20>

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: SQL Server DTS/FTP (SQL Serv2000)

    It's not something I've actually done, but looking at the Books Online for FTP, it indicates that all of the tools are available to do that, and that concept is used in some kinds of SQL Server replication (merges in particular). Hope this helps.
    Wendell

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL Server DTS/FTP (SQL Serv2000)

    Actually I looked at a book on DTS packages and the FTP service seems to be set up to download to a lan directory and then you can set up a text source to pull the data into a SQL Server, so the idea of going from SQL Server to FTP directly seems to be not supported natively. I already do the download manually (and need to) so the FTP service in the DTS package is not all that useful. I was curious if this is something that can be done easily and don't think that it is (at least for SQL Server 2000). Perhaps in newer versions? well, it's no big deal. Thanks for replying!

Posting Permissions

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