FIX: SSIS package execution fails when it uses DT_TEXT data type in SSIS 2012 or 2014

Applies to: SQL Server 2012 Business IntelligenceSQL Server 2014 Service Pack 2SQL Server 2014 Business Intelligence

Symptoms


Assume that you use Microsoft SQL Server Integration Services (SSIS) in SQL Server 2012 Service Pack 2 (SP2) or SSIS 2014. You run an SSIS package that transforms the data type from DT_TEXT to some other data type in a data flow. In this situation, the package execution may fail, and you receive an exception resembles the following:
Problem signature:
Problem Event Name: APPCRASH
Application Name: dtexecui.exe
Application Version: 11.0.5058.0
Application Timestamp: 5373fe18
Fault Module Name: KERNELBASE.dll
Fault Module Version: 6.3.9600.17055
Fault Module Timestamp: 532943a3
Exception Code: 00000001
Exception Offset: 00011d4d
OS Version: 6.3.9600.2.0.0.272.7
Locale ID: 1033
Additional Information 1: 5861
Additional Information 2: 5861822e1919d7c014bbb064c64908b2
Additional Information 3: d1d9
Additional Information 4: d1d94a13d3609d6b740644c12508f581

Resolution


The issue was first fixed in the following cumulative update of SQL Server.
 

Cumulative Update 11 for SQL Server 2014 SP2

Cumulative Update 2 for SQL Server 2012 SP2

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.