Solved

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

Posted on 2010-09-15
3
951 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 500 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

707 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now