bitScry

  • Home
  • About
  • Blog
  • Contact

SFTP

About this site

This is a blog to help me remember some of the coding challenges I’ve faced and hopefully help others out if they’re suffering the same problems.

Recent Posts
  • Serving Images from Blob Storage in an Azure Function
  • Redis Caching in .NET
  • Passing Environment Variables From Docker to .NET Web App
  • Retrieving Data from MySQL Stored Procedures in .NET
  • Excluding Child Properties from a List of Objects in Fluent Assertions
Tag Cloud

.NET .NET Core AAD API ASP.NET Core Authentication Authorization Azure Azure Active Directory Azure Function Azure Storage Blob Bootstrap C# Cloud Storage Console Application CSS DataTable Dependency Injection Dictionary Entity Framework Enum Extension Google HTML Image IP Address JavaScript jQuery JSON List MVC MVC 6 Newtonsoft RestSharp Serilog SQL Stored Procedure Stream Table Table Storage Test Web App Web Application WordPress

Programming

Data Transfer – SQL to SFTP CSV

Outputting a SQL table to a CSV file on an SFTP site is pretty much the same as outputting it to a local CSV file but with the added step of using SSH.NET to upload the stream. Full code for this can be found here. GetSqlRowsAsync Usage Usage – GZip Read more…

By Shinigami, 3 years6 January 2020 ago
Programming

Streaming Unzipping and Gzipping of files to Azure Storage

Azure Data Warehouse has a nice feature where it can access GZipped file blobs directly from Azure Storage as linked tables. The below code is for downloading zipped files from an SFTP site, extracting them, gzipping them and then uploading them to Azure Storage. This all takes place in memory Read more…

By Shinigami, 4 years2 November 2018 ago
Programming

Downloading SFTP Files in Console Applications

I use the WinSCP dll to download files from SFTP sites in SSDT, as shown here, but this approach doesn’t work in .NET Core applications as the WinSCP dll isn’t available as a NuGet package. An alternative to WinSCP is SSH.NET, which amoung other things, has the ability to download Read more…

By Shinigami, 6 years14 September 2017 ago
Programming

Downloading SFTP Files in SSDT

I often need to download files from an SFTP site in SQL Server Data Tools (SSDT), the best way I’ve found of doing this is a script task that hooks into WinSCP. WinSCP and it’s dlls can be downloaded here. Once installed, the dll should also be added to the Read more…

By Shinigami, 6 years14 September 2017 ago
  • Facebook
  • Twitter
  • Instagram
  • Email
Hestia | Developed by ThemeIsle