Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

FTP Task in SQL Job Report Success...but fails Expand / Collapse
Posted Tuesday, May 7, 2013 1:14 PM


Group: General Forum Members
Last Login: Monday, September 9, 2013 11:03 AM
Points: 21, Visits: 140
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?

Post #1450306
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse