Thank you so much for your time, I'm very appreciated. :-):-)
My works below:
I created 2 packages, both same method, run under proxy account.
Each package needs to export data from different tables, save to csv files and then upload to FTP and sFTP.
The one uploaded to ftp, i had no problem. It's completed and scheduled to run every 2 hours.:-P:-P:-P
The one needed to upload to sFTP, I had to download Winscp and then upload to sFTP. Everything run fine in BIDS and Integration manually, but failed in Job Scheduler.
If i scheduled a job to run directly from File System, job failed with error:
Executed as user: Domain\AgentService. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 4:14:37 PM Error: 2015-05-07 16:14:40.09 Code: 0xC0029151 Source: EPT - Perform SFTP Using WinSCP COM Utility Execute Process Task Description: In Executing "C:\Program Files (x86)\WinSCP\WinSCP.exe" "-script="\\sqlserver1\c\SSISProject\MyScript.txt"" at "C:\Program Files (x86)\WinSCP", The process exit code was "1" while the expected was "0". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:14:37 PM Finished: 4:14:40 PM Elapsed: 2.218 seconds. The package execution failed. The step failed.
If i created a batch file as you suggest, batch file run fine too.
Then I modified the command line, run with/without the configuration, failed again with error:
Executed as user: Domain\AgentService. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Option "DTEXEC" is not valid. The command line parameters are invalid. The step failed.