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
Author
Message
Posted Tuesday, May 7, 2013 1:14 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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?

Thanks,
Post #1450306
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse