Using Data Transformation Services, part 7: Transferring Files with DTS - File transfer from directory to directory
(Page 3 of 4 )
Choose Directory from the dropdown menu as shown. In this case, you indicate the path to both the Source and the Destination as shown in the next picture. In this case, files are being transferred from the Source, C:\Documents and Settings\computer user\My Documents, to the Destination, C:/FTPReceive folder.
Clicking on Files, in the File Transfer Protocol Task Properties window, brings up the window shown in the next picture. Here some three files have been chosen for transfer as shown. Clicking on OK completes the package definition.
The package can be executed in several ways as discussed in the previous tutorials, or as shown in the picture.
Next: FTP from Command line >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
