This Microsoft® Visual Basic® sample demonstrates how to use Data Transformation Services (DTS) to copy files that are not Microsoft® SQL Server™ files from a source to a destination. This sample copies Authors.txt in the local directory to the \Test subdirectory.
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Dtstasks\DTSFTPTask