SSIS Custom Object Type Transform Issue

Radwan Alchen 0 Reputation points
2024-02-05T20:50:53.3933333+00:00

I created a new tool for SSIS with a boolean data type output column, but when I test the tool, I received values "<Missing Reference>" on a column. The code I used is below. Can someone help me identify the problem?

public override void PreExecute()
{
      IDTSInput100 input = ComponentMetaData.InputCollection[0];
      IDTSOutput100 output = ComponentMetaData.OutputCollection[0];
      outputColumnInfo = new ColumnInfo[output.OutputColumnCollection.Count];
      Enumerable.Range(0, output.OutputColumnCollection.Count)
         .ToList()
         .ForEach(i =>
         {
                IDTSOutputColumn100 outputCol = output.OutputColumnCollection[i];
                outputColumnInfo[i] = new ColumnInfo
                   {
                      C_CodePage = outputCol.CodePage,
                      C_DataType = outputCol.DataType,
                      C_ID = outputCol.ID,
                      C_ObjectIndex = output.OutputColumnCollection.GetObjectIndexByID(outputCol.ID),
                      C_Length = outputCol.Length,
                      C_LineageID = outputCol.LineageID,
                      C_Name = outputCol.Name,
                      C_ObjectType = outputCol.ObjectType,
                      C_Precision = outputCol.Precision,
                      C_Scale = outputCol.Scale,
                      C_BufferIndex = BufferManager.FindColumnByLineageID(input.Buffer, outputCol.LineageID)
                   };
         });
}



public override void ProcessInput(int inputID, PipelineBuffer buffer)
{
       if (!buffer.EndOfRowset)
       {
          while (buffer.NextRow())
          {
             for (int x = 0; x < inputColumnInfo.Length; x++)
             {
                buffer.SetBoolean(outputColumnInfo[x].C_BufferIndex, false);
             }
          }
       }
}

Also, I have attached an image that might help. User's image

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,363 questions
{count} votes