Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 39
  • Last Modified:

SSIS FTP Example

I need to set up an SSIS (2005...yeah...I know) FTP Task

connect to remote server
delete contents of remote folder including sub folders
copy entire local directory tree up to the remote server

Any example links?
0
lrbrister
Asked:
lrbrister
2 Solutions
 
Brian CroweCommented:
0
 
Tony303Commented:
Another idea is to use a "Putty" type ftp app.
And use the SSIS Execute Process Task

I use WinSCP

Install Win SCP on the server where SSIS is running.
In the Execute Process Task put the path to the .exe in the Excecutable field
Then all the correct syntax for the Arguements field to connect, set paths for log files, source and destinations etc.
SSIS-Execute-Process.docx
0
 
lrbristerAuthor Commented:
Thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now