I am having a problem, i am trying to schedule a SSIS Package through SQL Server Agent. Every time i run schedule is run fine or not i am having error ( Patch not find), I am just transfer a file from local to server. and error are saying server file path is not find. but if use the same package to transfer file from one directory to other its run fine. Any extra setting when i transfer a file from one server to other?
Any advise would be big help! Thanks.
This problem is usually a permissions issue. Check to ensure the account you are running the schedule with has access.
Thanks Mike for your reply, I checked both account has same rights.