LineageID string or Integer

See more:

SQL-Server

Hi,

I'm trying to fetch lineageId of output columns in a SSIS Package. I'm traversing SSIS Package as XML Document in C# code.

No issue in traversing and fetching data from the nodes in the package, but facing issue when I'm trying to fetch LineageID.

I many forums and articles said that LineageId generated in SSIS Package is a Unique Integer value for that particular package, so I'm trying to convert LineageID to an integer value. But it seems to be a String value.

Kindly clarify my doubt. Is lineageid STRING OR INT?

If it is Int then please tell me how to find it.

foreach (var x in NodeCollection)
            {
                var outputCollection = x.Elements("outputColumn");
                foreach (var output in outputCollection)
                {
                    string Name = output.Attribute("name").Value;
                    long LineageId = Convert.ToInt64(output.Attribute("lineageId").Value);
                }
            }

By debugging with Breakpoint "output.Attribute("lineageId").Value" is returning following value

"Package\DFT\SRC.Outputs[OLE DB Source Output].Columns[TYPE]"