ERROR: AccessViolationException: Attempted to read or write protected memory

Issue:

Sometimes when you execute SSIS Package under 2012 or 2008 Runtime (64 bit only) you may get following error using JSON Source.

[JSON Source [2]] Error: System.Exception: AccessViolationException: Attempted to read or 
write protected memory. This is often an indication that other memory is corrupt.. RowNumber=1
-- or --
[JSON Source [2]] Error: System.Exception: NullReference: xxxxxxxxxxxx.. RowNumber=1
 

Here is what works and doesn't work when such error occurs

1. The package works fine in SSIS 2017, 2016, 2014 but Failed in SSIS 2012 or 2008
2. When tried to execute file system package via C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\DTExecUI.exe  Worked fine  
3. Dtexec 64 bit - Failed
4. Dtexec 32 bit - Worked
5. VS - Execute package in 32-bit mode - Worked
6. VS - Execute package in 64-bit mode - Failed

So please continue using 32 bit for packages that fail. Otherwise, you can use 64-bit mode by default.

Fix-1: 

To fix this issue change following property to False (so it runs under 32-bit mode)

Fix-2:

Try to check if you have parallel flows (Use of Multicast). Avoid many parallel flows. 

Fix-3: 

Try to check DT_TEXT or DT_NTEXT datatypes in flow and see can change to DT_STR(8000) or DT_WSTR(4000) and run it again to see error goes away.

 

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/