Introduction

The FileXferUtil (File Transfer Utility) is a Managed File Transfer (MFT) project that was built to meet the following needs:

• Centralize the configuration of file transfers.
• Eliminate the use of clear text passwords in script files.
• Provide auditing and reporting of transferred files.
• Encrypt / Decrypt files during transfer (PGP and AES).
• Check digital signatures of PGP files received.

Other Considerations and Features

• Transfers run as a Windows console application and is scheduled via Windows Task Scheduler, SQL Server Agent, or any other scheduler for Windows.
• The following protocols are supported via WinSCP (SFTP, SCP, Amazon S3, FTP, FTPS).
• UNC file transfers over SMB/CIFS for remote shares.
• Azure block storage is supported via the Microsoft Azure library for .Net.
• Backblaze is supported via WinSCP / Amazon S3 protocol.
• This project was developed with transferring smaller transactional files in mind rather than larger one off transfers.

System Requirements

• Windows Server or Desktop
• .Net Framework 4.8
• SQL Server (Most versions and editions should be OK, it was developed and tested on SQL Server 2017)
• SQL Server Reporting Services for reports (optional, standard edition and above)
• SQL Server Database Mail for email notifications (optional, standard edition and above)