Each SQL Server unit test contains a single pre-test action, test action, and post-test action. Each of these actions in turn contains the following: A Transact-SQL script that executes on a database.

Save that batch script with a .bat extension, like GetCSV.bat Executing that batch script will open up an ftp connection and fire off your commands resulting in filename.csv being downloaded.