SSIS : I am trying to get the error column name using the script component. However I get error for the code below

Question

I am trying to get the error column name using the script component but am getting an error for the below line:

var componentMetaData130 = this.ComponentMetaData as IDTSComponentMetaData130;
Row.ErrorColumnDescription = this.ComponentMetaData.GetIdentificationStringByID(Row.ErrorColumn);

The type or namespace 'IDTSComponentMetaData130' could not be found.

If anyone can guide me for the same.

Answer 1

I don't think "as" is legal syntax in a Script Component. Can you try removing that so the code is:

var componentMetaData130 = this.ComponentMetaData;

EDIT: Ah, my mistake. I think I've found the code you're referring to. Does replacing the "var" with "IDTSComponentMetaData130" work:

IDTSComponentMetaData130 componentMetaData = this.ComponentMetaData as IDTSComponentMetaData130;
Row.ErrorColumnName = componentMetaData.GetIdentificationStringByID(Row.ErrorColumn);

Answer 2

IDTSComponentMetaData130 is SQL Server 2016 and above only.

It is described here: https://learn.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.dts.pipeline.wrapper.idtscomponentmetadata130?view=sqlserver-2016

If you go to that link, you'll see a dropdown that shows the available versions.