I would like to set up an automated process to send files to a particular server. The server will be using managed file transfer - and I have SSIS 2005 and 2008.
I have tried to set this up using the FTP task on SSIS but I am getting a failure with connection.
I'm not sure if this is due to a connectivity issue, or because I simply can not use the FTP task when what I should be using is a MFT?
can anyone help advise me please?