Hi,

I have an SSIS Package with "Process Task" component which will call an ".exe" file(c# .net console application) . sometimes we are getting following error from ETL Package.

In Executing "C:\Release\Sample.exe" "32410" at "",The process exitcode was "-1073741819" whilethe expected was "0".

In event viewer I can see exception code as

Faulting application name: Sample.exe, version: 1.0.0.0, time stamp: 0x555c24e7

Faulting module name: Sample.exe, version: 1.0.0.0, time stamp: 0x555c24e7

Exception code: 0xc0000005

Fault offset: 0x000096de

Not sure what was the problem . Please help giving suggestion

Regards,

Naveen M

Hi Naveen,

As per my understanding, it inquires with the Sample.exe vendor as to what an exit code of "-1073741819" means.

What happened here is that SSIS attempted to run the application, the application may or may not have executed properly, but it returned a value of -1073741819.  SSIS is interpreting a non-zero return value from the application as an error. This may not even indicate an error condition - it may be a "valid" return code.

Since you can run Sample.exe successfully on its own, please make sure the user has permissions to access the .exe and execute the command.

Besides, please enable logging in your SSIS package, and analyze the specific error message when the issue re-occurs. For more details, please see:
https://msdn.microsoft.com/en-us/library/ms141212(v=sql.120).aspx

Thanks,
Katherine Xiong