SSDT 2017 SSIS not able to open dtsx file has Oracle connection

Christopher Lee 1 Reputation point

On Windows 2016 and SQL 2016. Converting 2012 SSIS to 2016. Ran into devenv.exe application error when trying to open dtsx files have Oracle connection.

Instruction at 0x0000000077C7DF93 referenced memory at 0x000000000000004. Memory could not be written.

Checked Windows Event - Event ID:1026

Application: devenv.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(System.Object)
at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.AcquireConnection(System.Object)
at Microsoft.DataTransformationServices.Design.ConnectionValidationModel.CheckConnection(Microsoft.SqlServer.Dts.Runtime.ConnectionManager)
at Microsoft.DataTransformationServices.Design.ConnectionValidationModel+<>c__DisplayClass1.<StartValidation>b__0(System.Object)
at System.Threading.QueueUserWorkItemCallback.WaitCallback_Context(System.Object)
at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch()
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()

Reboot the server but still no luck. Any hint? Thanks.


SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,520 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 35,226 Reputation points

    Hi @Christopher Lee ,

    If you run other dtsx files will the issue occur?

    Exception Info: System.AccessViolationException

    I did some research about the error message and found it may be related to registry.

    1) Open up regedit (Win+R and then type regedit)
    2) Go to File -> Export and export your settings to have a backup in case this solution fails for you (but otherwise this step is optional)
    3) Locate the entry HKEY_CURRENT_USER/Software/Microsoft/VisualStudio
    and completely delete both 14.0 and 14.0_Config entries
    4) And this should be it, just start Visual studio as normal and it should automatically recreate all of its missing registry entries

    Please have a try about the steps above.



    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

  2. Christopher Lee 1 Reputation point

    It turns out that MSADORA is no longer supported. No more application error after removing MSADORA from connection string.

    0 comments No comments