I am trying to create a script to go out and log onto an SFTP server and download our file monthly and then place it somewhere on the computer. I am wondering if anyone else has done this. I have seen a little documentation from filezilla but maybe someone has a better way of doing this or can help with the commands I need to use.
I recently setup an "automated build server" for my software projects. All software projects get built and bundled into a zip file. In theory, this zip file will be downloaded via FTP to several different servers. I am trying to build a powershell script that will download my package and unzip it into the desired directories.
Whenever powershell starts to download the source .zip file, it hangs. I can see the file appear on the harddrive, but then disappears when the script fails. It never gets any bytes from the FTP server. I then receive this error:
Good news first, I cobbled together a working solution for filezilla server certs with letsencrypt using openssl. I just was hoping to get some help making it prettier as I am more of a batch-script guy.
does anyone have a tutorial on how to get filezilla ftp server working with certify the web? The script is a big help but i am unclear without a lot of trial and error all the steps necessary to get certify the web and filezilla working together. Thanks.
I wrote a little powershell script to look in our FTP folder for files that have arrived in the last hour. It's not something I run through SAM....It's just a scheduled task that kicks off every hour and emails me what it finds....name, creation time, size....that's pretty much it. I'm not sure if it's the same thing you're looking for...but I'd be happy to share it with you.
You MUST have IIS Powershell Snap-In installed and run this command in the IIS Powershell command window not the standard powershell command window. More info at -iis-with-the-iis-70-powershell-snap-in/
UmbracoConfig.ps1 - This is where you configure all your settings. Please follow the instructions in the file it's pretty will documented.
If you're not using filezilla server you can swap it out for another application this is the same for Amazon Web Services SES service.
SQL Server doesn't ship with an SFTP Task so your options are to buy a third party SFTP Task like nsoft or cozyroc, write a batch or powershell to transfer the file usin WinSCP or Filezilla and use the Execute Process Task or use a Script Task and program the transfer using C# or VB.Net.
the script works fine, but I encountered strange behavior when I run the script.
The memory usage of the powershell process consumes around 95% of the system (3.5GB) and the machine is not usable anymore.