1
Vote

DataTap on the Path after SCD(slowly changing dimension) fails

description

I am using SSISTester to write unittest for a SSIS package. in SSIS Package there is DFT which fetches data and using SCD either inserts or updates the data. while i am using [DataTap] i get the data on all paths above SCD but after SCD if i try to tap data it fails. the same code runs well if i dont use datatap. and the destination gets updated properly.

below is the error i get while i use DataTap in the path which is from SCD to Script or further Script to OLEDBCommand

[Id]: -1073450910 [Name]: -1073450910 [Source]: DFT Name [Description]: System.NullReferenceException: Object reference not set to an instance of an object. at sfHIxK7aKvefIaXjtS.jfyakfu0C02YvDayCk.e68vYSLVe(DataType , Object ) at SSIS.Test.PipelineExtensions.PipelineDataTap.ProcessInput(Int32 inputId, PipelineBuffer buffer) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket) [Id]: -1073450974 [Name]: -1073450974 [Source]: DFT name [Description]: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Data Tap 3" (983) failed with error code 0x80004003 while processing input "Data Tap Input" (988). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

comments