Jim Russell (5/21/2008)
I was disappointed when, per the MS Connect site, that the horrible flaw in the SSIS FTP task was not fixed. (The flaw is that the source/destination directory is arbitrarily forced to start with a "\", effectively rendering the FTP task useless when working with mainframe systems.)(Just venting...)
My hatred of the FTP task is that it is only FTP -- not SFTP. I'm developing a file transfer job right now and have to run the SFTP step as a command task.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]