Hi,

Sorting out FTP problems is not as hard as you might think. I do agree with you on the un descriptiveness of SSIS errors though.

The 1st problem to check is port 21, a so called "FTP" port. To make sure that the port is OK, run http://ftp.exe from the command line and simulate the same operation that you were trying to achieve from SSIS. If that one fails, your problem is lying around firewall/permissions/restrictions.

The 2nd problem is FTP credentials or to be exact how they saved/retrieved. The rule of thumb in that case is to rely on SQL Server, i.e. to use "Rely on server storage and roles for access control" package protection level. This approach should remove all FTP credentials problems altogether (excluding mistypos of course).

My general advice to you is start small. Trying to put all the pieces together right away in SSIS is a recipe for disaster unless you're well experienced "decryptor" of SSIS errors.

Good luck,

Steve Rezhener.