Hello,
I'm uisng FTP task for sending file to different domain.
I have spacial ID for access FTP and using the same FTP connection manager. It is working fine if i'm running this task manuly but not working as sql agent job. Do I need to have same ID for SQL agent service and FTP process. My sql agent service is running in different account.
I appreciate you input for this issue.