Solved

script to Get 2 text files from remote server

Posted on 2014-07-26
5
191 Views
Last Modified: 2014-08-06
Hi,

We have 2 txt files in the remote server, which we need to download to our local server folder.
 We couldn't use the FTP task on SSIS, since this is a Secured FTP.
I'm looking for a script to run in SSIS 2009, so that i can
1. Get those files from the remote server
2. Delete those two files on the remote server

Can someone help with the script?
0
Comment
Question by:pvsbandi
  • 2
  • 2
5 Comments
 
LVL 32

Expert Comment

by:Robberbaron (robr)
Comment Utility
are you able to installed the ftp client part of putty ?
this can be scripted but sftp needs a 3rd party app ...
0
 

Author Comment

by:pvsbandi
Comment Utility
We have got filezilla.. Is it possible to script based on that?
0
 
LVL 32

Accepted Solution

by:
Robberbaron (robr) earned 500 total points
Comment Utility
no filezilla is a GUI based app.. (and a good one !)

with psftp you can start the application with an input file of commands.
http://www.putty.org/   or http://the.earth.li/~sgtatham/putty/0.53b/htmldoc/Chapter6.html

also see http://winscp.net/eng/docs/scripting  which i have used before.
0
 

Author Closing Comment

by:pvsbandi
Comment Utility
Thanks! We used Winscp
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Welcome to part one of a multi-part tutorial series, VBScript for Windows System Administrators.  The goal of this series is to teach non-programmers how to write useful VBS code to automate their environment, and perform tasks faster, and in a more…
When it comes to writing scripts for a Client/Server computing environment it is essential to consider some way of enabling the authentication functionality within a script. This sort of consideration mainly comes into the picture when we are dealin…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

772 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

12 Experts available now in Live!

Get 1:1 Help Now