Let’s understand about LineageID property in SSIS
- LineageID is a very important property in SSIS packages.
- Every column used in dataflow has atleast one LineageID.
- It’s an integer value which identifies the column in the buffer.
- A column can have more than one LineageID and this is based on the types of transformation outputs the column has (or passes through) in the data flow.
Below is the image of column properties in ADO.NET Source – Advanced Editor (right click on the ADO.NET Source in Data Flow task and select Show Advanced Editor)
Image : 1
Image 2: How to open Advanced Editor for ADO.NET Source (in Data Flow Task)
Happy Learning !!!