Is ther eany tool arrond to check the table names and fields names which one DTS has. I need to know the DTS which are bind with given table or filed name. Thankx in advance
I haven't seen such tool or application to findout the objects. I believe only the way is to go thru the DTS package from designer. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Everybody is waiting for completely new mssql 2005 dts. Even the name is changed. It means, I don't expect new, old dts related, tools.
True the DTS is renamed as Integration Services in SQL 2K5 and expect few good things too. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
quote:I need to know the DTS which are bind with given table or filed name.I had the same problem when I took over app I am working on right now. I decided to use stored procedures and UDFs for all sql code inside dts packages. I put comment in each sp where this proc is called from. That way when I need to know where specific table or row is used I find dependant procs and reading comments I can find if it is dts package involved. I use UDF for reference values that otherwise would be hard-coded, like UDF_StatusInactive, UDF_DataRetentionPeriod and so on.
