If you do a lot of file migration or exchange with Microsoft SQL server you have probably had to grab a file via ftp. In most cases if you have automated this task you may have done this by either a vbs file or a bat file, or a DTS package that calls an FTP client. Well, Dan Woolsoton (A new Co-worker) has found a great tool to replace the default DTS FTP calls. It is called SQLDTS, it has many features and settings you can dynamically replace. You can read Dans full article HERE
Testing FTP functionality