SSIS failed with error 43% in Windows scheduler but no problem manually running the batch file...

[nataliedw]

hello folks, I got headache to figure out SSIS SQL 2005 error when windows task scheduler is triggered... I setup the batch file like below to run it every morning, "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /f c:\BAT\SSIS\DATATRAN.dtsx >> c:\BAT\LOG\DATATRAN.log" it had been working until last month, now I can run this batch file without any problem manually and no problem to run the scheduled task manually, but it shows errors when run the scheduled task every morning... SSIS is stuck in the process 43% completed, Is there anyone can give me tips? thanks!!