FTP Automated downloader
I dont have much experiance with SSIS but i know this is doable on it. What i am looking for is a script that would let me download from an FTP website. Couple of critierias that are important: unix server files from server are deleted every four days that is why i want to download the files to company hard drive. i dont want a duplicate of folders/files downloaded every time. when i log in as the admin, there are 20 folders. each folder is named after a company member. when the company member logs in they see only the content of the folder that is specified to them. i want to download the content of the folders. because if i download the folder. it will just download the whole folder and i'll have a lot of folders by the same name. so the thing i did was make directories on my hard drive that has the same name as the folders i see. (this part might be confusing so ask me to explain if needed. ) also i think it would be a good idea to delete the contents of the folder once the download happens so no duplicates are downloaded. if anyone has written a similer script or has a SSIS(visual studio) file that will help me out, i'd appricate it. basic steps: log in ftp website with username and password. go into folder A download the content of folder A to hard drive(time stamping would help) delete the content of folder A. go into folder B download the content of folder B to hard drive delete the content. keep on doing until done to all folder. Thank you!
July 18th, 2012 1:59pm

Are you going to actually process the files? If all you want to do is automate a download then I would look at products like FileZillaChuck Pedretti | Magenic North Region | magenic.com
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2012 2:16pm

im sorry as i said in new so i dont know what you mean by processing the files. i just want an exact replica of the content of the folder. if you can show me the way FileZilla does the automatic download. that would be great!
July 18th, 2012 2:25pm

I'd suggest using google - but to get you started here is a video of one of the many tools you could use for this type of job http://www.youtube.com/watch?v=p62RUoJgJfAChuck Pedretti | Magenic North Region | magenic.com
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2012 2:56pm

I'd suggest using google - but to get you started here is a video of one of the many tools you could use for this type of job http://www.youtube.com/watch?v=p62RUoJgJfAChuck Pedretti | Magenic North Region | magenic.com
July 18th, 2012 2:56pm

anyone got a code that will do this??
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2012 2:33pm

Timestamp is difficult. The standard ftp connection that SSIS uses doesn't return file properties like date. Maybe you could try something with the Foreach FTP File Enumerator to Loop through the ftp folder(s). Within the foreach loop you could forexample add (besides the ftp task) an execute sql task to verify if the ftpfilepath allready exists in a table with url's from downloaded files.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
July 20th, 2012 3:35pm

i will try this and see if it works. will let you know if i am sucessful. thank you!
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2012 3:55pm

do i have to download Foreach FTP File Enumerator - SSIS 2008 download ??? also does this go in subfolders and download the content there? i would like to be able to mirror the subcontent folders. thank you!
July 23rd, 2012 1:39pm

do i have to download Foreach FTP File Enumerator - SSIS 2008 download ??? also does this go in subfolders and download the content there? i would like to be able to mirror the subcontent folders. thank you! yes download the 2008 or 2012 version on http://microsoft-ssis.blogspot.com/2012/01/custom-ssis-component-foreach-ftp-file.html. You can find the installation details (next, next, finish) there. It has a simular traverse folder option like the standard file enumerator which allows you to loop through subfolders: Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2012 2:49pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics