Post reply

SQL 2000 DTS/Job Name

  • September 16, 2008 at 11:52 pm

    #192846

    Hi all,

    I would like to ask if how can I retrieve/is there a way I can get DTS/Job Name given only a table name or stored procedure.

    Thanks in advance.

  • September 18, 2008 at 4:38 pm

    #873961

    This doesn't appear to be a SQL 2008 question, but since nobody has responded...

    The only way to search for a string in a job is to script it out and open it in an editor. You'd have to save a DTS package as a vb file then open it with an editor.

    Greg

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply