Solved

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

Posted on 2010-09-15
3
964 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

631 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