Home > Archive > SQL Server Programming > November 2005 > Get files from FTP using DTS
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Get files from FTP using DTS
|
|
| fuhlendorf@hotmail.com 2005-11-29, 4:00 am |
| Hi,
I seem to face a problem getting the right files from an FTP-server.
I do need to logon to the ftp site, go into a sub-directory and
transfer the files in that directory. However the transfer is always
carried out one the main directory eventhough I have explicit defined
that it is the files in the sub-directory - how can that be?
Additional: What if new files are added to the directory, will they
also be transfered.
/Ren=E9
| |
| John Bell 2005-11-29, 4:00 am |
| Hi
You may want to look at http://www.sqldts.com/default.aspx?302 and download
their SQLDTS FTP task. You can specify the remote directory in the
TransferXML element.
I am not sure if files are being copied into the directory whilst you are
downloading them will cause you a problem. If these files are exclusively
opened then you will get an error if you try to read them. You can use
checksums or check the download file's size against the version on the server
to make sure that a transfer has been sucessful.
John
"fuhlendorf@hotmail.com" wrote:
> Hi,
>
> I seem to face a problem getting the right files from an FTP-server.
>
> I do need to logon to the ftp site, go into a sub-directory and
> transfer the files in that directory. However the transfer is always
> carried out one the main directory eventhough I have explicit defined
> that it is the files in the sub-directory - how can that be?
>
> Additional: What if new files are added to the directory, will they
> also be transfered.
>
> /René
>
>
| |
|
| Thanks a lot - just the tool I needed.
/Ren=E9
|
|
|
|
|