Post reply

Where Is DTS Package Names Stored?

  • September 19, 2003 at 1:41 pm

    #106230

    In which DB and table can I find the package names?

    Master or MSDB

    Thanks

  • September 19, 2003 at 1:43 pm

    #475113

    Let me rephrase, is there a way I can read the last date a package was ran?

  • September 19, 2003 at 1:57 pm

    #475117

    You have to enable the logging in your package --> property --> Logging --> Log package execution in SQL Server.

    Once you done that, you will be able to see the execution date from system table sysdtspackagelog in MSDB. Your package name is in sysdtspackages in MSDB too.

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

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