• Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 43
  • 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
Larry Brister
Asked:
Larry Brister
2 Solutions
 
Brian CroweDatabase AdministratorCommented:
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
 
Larry Bristersr. DeveloperAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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