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
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: Friday, March 20, 2015 12:37 PM
Points: 9, Visits: 245
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



Group: General Forum Members
Last Login: Today @ 4:31 PM
Points: 2,737, Visits: 7,735
the following link indicates the issue is sql server agent service account does not have sufficient permissions
Post #1511333
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse