SQL Server Performance

Tool to Check the DTS components

Discussion in 'Third Party Tools' started by dineshasanka, Feb 17, 2005.

  1. dineshasanka Moderator

    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
  2. satya Moderator

    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.
  3. dineshasanka Moderator

    well, may be a good innovation if some body can do this!!
  4. mmarovic Active Member

    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.
  5. satya Moderator

    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.
  6. mmarovic Active Member

    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.

Share This Page