[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SSIS How to move a list of files from FTP to Local machine

Posted on 2010-09-15
3
Medium Priority
?
979 Views
Last Modified: 2013-12-16
Hi expert ;

I have an FTP site that receives multiple files per day. I need to connect to the site, pull all the files ( transfert the files from FTP site to my local machine), and move the files to an local Archive folder and finaly delete the FTP site files

How to do that using SSIS if any script can you please provide it me with C#

Thanks
0
Comment
Question by:Fatehbourghoud
  • 2
3 Comments
 
LVL 30

Accepted Solution

by:
Reza Rad earned 2000 total points
ID: 33685970
Hi,
simply just you need to use FTP task
set operation as Retrieve files
set local directory
set remote path.
the only note here is that you should use mask for remote path. for example if you want to get all files you *.* at the end of remote path.
look at attachment ...

1.jpg
0
 

Author Closing Comment

by:Fatehbourghoud
ID: 33686097
Verry stisfied by reza services

Thanks
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 33686239
Glad to help,
Regards
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Suggested Courses

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question