Find the fields in a DTS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Find the fields in a DTS

I have set of DTS. I am planning to drop some fields. Is ther eanyway or any tools where i can get to know what are the dts that will be effeted from the action
You mean you want to drop columns from table that may be used by dts package?
quote:Originally posted by mmarovic You mean you want to drop columns from table that may be used by dts package?
yes,
before droping or renaming the column i need to know what are the dts that were effcted by this columns
U can check the edit all package properties to check the dependency and can include those columns which u want
quote:Originally posted by ranjitjain U can check the edit all package properties to check the dependency and can include those columns which u want

ranjitjain,
I am looking for a tool which i can do this with minimum effort.
]]>