Home > SSIS > SSIS: What is LineageID in SSIS?

SSIS: What is LineageID in SSIS?

LineageID:

  • It’s an integer pointer to the column within the buffers
  • In Data Flow every column has atleast one LineageID.
  • A column can have more than one LineageID. This is because when column passes through various transformation outputs in a Data Flow, it holds the pointer to the column in a buffer in data flow. In the below image you can see the column EmpNo (Sort Input)  has a LineageID: 58

  Image 1: LineageID for the EmpNo column in a Sort Input

image

Image 2: LineageID for the EmpNo column in a Sort Output is different

image

Categories: SSIS
  1. No comments yet.
  1. No trackbacks yet.