Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ducletan
Starting Member
25 Posts |
 Posted - 2011-07-27 : 02:56:37
|
| In SQL server2005,show me the way to know does file exists on remote FTP serverThanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-07-27 : 03:11:25
|
Use SSIS and the FTP control.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
ducletan
Starting Member
25 Posts |
Posted - 2011-07-27 : 04:22:58
|
| Can you explain more clearly ?tell me code for example |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-07-27 : 08:49:53
|
My first question is "Why do you want me to spoonfeed you?".Second question is "If you are going to maintain the code, why are you unwilling to study SSIS?".It's fairly uncomplicated. Start a new SSIS project, add a FTP connection and enter the values to connect to the ftp server.Depending on what you want to achieve, add more components to the package according to your will.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
|
|
|
file exists on remote FTP server