How do i get the package lineage inside the DTS pacakage?
I would like to insert the lineage to a log table when the
pacakage is executed. Can anyone help regarding this?
(The LineageFullID property is exposed by the
DTS.PackageLineages object. But i'm not sure how to get
the lineage for that package instance )

Thanks in Advance,
Arun

In Package Properties | Advanced you can enable lineage as source columns
for your transformations

Allan

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Arun" <arun.ns (AT) db (DOT) com> wrote

Allan,
thanks for the reply. I'm not able to understand what this
does. How will this help in getting the lineage
information written to sysdtspackagelog table from within
the pacakge?
Thanks,
Arun