Dear all:
I have a package that have been running successfully all the time. But once in a while an error will occur to the Execute process task, the error message is as follows:
In Executing "D:\Apps\DataLoader.exe" ""Data Source=dft;Initial Catalog=sampleDB;Integrated Security=SSPI;" D:\Unzipped\Sample.data 2 1482 2009 16" at "", The process exit code was "255" while the expected was "0"
Since the task will run on success and the success code is '0' while the execute task return the code 255.
What could be wrong here? I don't think it's the permission issue since the job is running successfully for other batches even now. I don't think it's a disk space issue since files with bigger sizes are running successfully.
Could anyone please shed some lights?
Thank you and best regards,