Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Oracle OLE DB connection Crashing in SSIS 2012 Expand / Collapse
Author
Message
Posted Monday, November 4, 2013 12:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 17, 2014 7:37 AM
Points: 9, Visits: 239
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
Post #1511235
Posted Monday, November 4, 2013 5:56 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:45 PM
Points: 2,236, Visits: 5,668
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
Post #1511333
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse