I have a FTP batch file which I call from DTS package. It all works fine when I right click on the package and execute it now. However when I schedule it, it comes with following error :
Step Error Description:CreateProcessTask 'DTSTask_DTSCreateProcessTask_1': Process returned code 2, which does not match the specified SuccessReturnCode of 0.
Step Error code: 80040496
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4900