I have a FTP Task in a SSIS Pkg that ran fine until I had to change my password mid-way through the full project, and the task stopped running on schedule. I set up a new account, using the same permissions as my original, added it to the proxy and tried to copy all permissions I had.
Now the SQL Job will run, and displays "success" after 3-4 seconds, and when I check the log it shows success, however I know that it running too quick and when I check it has not actually brought over any files.
I am assuming this is a permissions issue, but I have gone through every share, and security login and credential I can think of and compared to my original settings and retried, with the same result.
Any new ideas?
Thanks,