This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Hello,
Hello with error caused by the GetIdenfificationStringByLineageID. I'm trying to get the actual error column name and I can't get pass this error message.
Thanks,
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 85%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJX%3C/text%3E%3C/svg%3E)
Hi @Wiseguy ， Welcome to Microsoft Q&A,
Make sure you include necessary namespaces.
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
using Microsoft.SqlServer.Dts.Runtime.Wrapper;
Try using the following code:
// Assume 'this' is an instance of ScriptMain which inherits from UserComponent
// 'Row' is the input buffer row with the ErrorColumn property.
string columnName = "";
int errorColumnId = Row.ErrorColumn;
if (errorColumnId != 0)
{
IDTSBufferManager100 bufferManager = this.BufferManager;
IDTSComponentMetaData100 componentMetaData = this.ComponentMetaData;
// Iterate through all input columns to find the matching lineage ID
foreach (IDTSInputColumn100 inputColumn in componentMetaData.InputCollection[0].InputColumnCollection)
{
if (inputColumn.LineageID == errorColumnId)
{
columnName = inputColumn.Name;
break;
}
}
}
else
{
columnName = "Unknown column";
}
// Use the column name as needed
The code is working now. Please see my updated post.
Thank you for your response and input.
Thanks!
You get the error message, because "ComponentMetaData" don't have a method anmed "GetIdenfificationStringByLineageID" and I can't find anything about online.
Hi @Olaf Helper
Thanks for the response.
Yea, I had similar challenges finding something online. However, the code works by removing the "this" keyword from the line of code. So, the below modification is working fine.
string myColumnName = componentMetaData.GetIdentificationStringByID(Row.ErrorColumn);
Yea, I had similar challenges finding something online. However, the code works by removing the "this" keyword from the line of code. So, the below modification is working fine.
string myColumnName = componentMetaData.GetIdentificationStringByID(Row.ErrorColumn);