Introduction

The FileXferUtil (File Transfer Utility) project 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 (key id only).

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).
• 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.6
• SQL Server (Most versions should be OK, it was developed and tested on SQL Server 2017)
• SQL Server Reporting Services for reports (optional)
• SQL Server Database Mail for email notifications (optional)