What is LineageID in SSIS?

Let’s understand about LineageID property in SSIS

  1. LineageID is a very important property in SSIS packages.
  2. Every column used in dataflow has atleast one LineageID.
  3. It’s an integer value which identifies the column in the buffer.
  4. 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 !!!


2 thoughts on “What is LineageID in SSIS?

  1. Pingback: What is LineageID in SSIS? | SQLThreads | Sladescross's Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s