SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.