In the SQL Server Unit Test Designer, the TestInitialize and TestCleanup scripts are referred to as the common scripts. The earlier example assumes that the two unit tests are part of the same test ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server 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.