Oracle OLE DB connection Crashing in SSIS 2012

• shanmugam Narayanan

  Old Hand

  Points: 301

  More actions

  November 4, 2013 at 12:09 pm

  #300008

  Oracle OLE DB connection in 2012 SQL instance \ SSIS package is crashing with this error. Any one faced with similar problem \ error.

  The test connection is working fine \ tnsnames.ora is setup fine, Its crashing with dump when it tries to pull the data.

  Any help would be greatly appreciated.

  Dump Summary

  ------------

  Dump File:SQLDmpr0018.mdmp : C:\Program Files\Microsoft SQL Server\110\Shared\ErrorDumps\SQLDmpr0018.mdmp

  Last Write Time:11/4/2013 10:38:57 AM

  Process Name:DtsDebugHost.exe : C:\Program Files\Microsoft SQL Server\110\DTS\Binn\DtsDebugHost.exe

  Process Architecture:x64

  Exception Code:0xC0000005

  Exception Information:The thread tried to read from or write to a virtual address for which it does not have the appropriate access.

  Heap Information:Not Present

  System Information

  ------------------

  OS Version:6.1.7601

  CLR Version(s):4.0.30319.1008

• prvmine

  SSCertifiable

  Points: 7007

  More actions

  November 4, 2013 at 5:56 pm

  #1664008

  the following link indicates the issue is sql server agent service account does not have sufficient permissions

  http://social.msdn.microsoft.com/Forums/en-US/a8902350-55e5-4844-afcc-8493a588ae3f/unexpected-termination-while-running-ssis-packages?forum=sqlintegrationservices