Search code examples
sql-serverssissql-server-2012etlssis-2012

Why does VS 2015 SSIS hang when changing expression


I am using a virtual machine Developer environment at work, and when I change an expression in my Visual Studio 2015 SSIS (from ".xls" to ".xlsx") the whole VS program hangs.

(the expression is located in the properties of a Microsoft ACE.OLE.12.0 connection manager's property).

What could be the problem?

EDIT: Error (also posted in comment)

Problem signature: Problem Event Name:APPCRASH 
Application Name:devenv.exe 
Application Version:14.0.25123.0 
Application Timestamp:56f22f32 
Fault Module Name:mso40uiwin32client.dll 
Fault Module Version:16.0.4519.1000 
Fault Module Timestamp: 58bed810 
Exception Code:c0000005 
Exception Offset:00166226 
OS Version: 6.3.9600.2.0.0.272.7 
Locale ID:3081 
Additional Information 1: 5861 
Additional Information 2: 5861822e1919d7c014bbb064c64908b2 
Additional Information 3: 5f25 
Additional Information 4: 5f2531ae070278f893fa99352dadd49e

Solution

  • I believe my DEVELOPER virtual machine was broken.

    I used a new DEVELOPER VM and everything works fine now.