Post reply

How to keep DTS Logs

  • April 24, 2008 at 3:49 pm

    #71487

    Is there any way to keep DTS Logs when Migrating. We copy DTS Packages from Production to development to then bring back to Prod. Is it possible to keep the logs with the moves/transfers?

    ¤ §unshine ¤

  • April 24, 2008 at 5:20 pm

    #806932

    No. You have to move the logs separately. If you log to SQL Server, the data is in msdb- sysdtspackagelog, sysdtssteplog, sysdtstasklog. if you log to an error file, it will be whereever you create the file.

    Greg

  • December 2, 2008 at 6:44 am

    #906190

    Sorry everybody but perhaps an stupid doubt: I have not the tables msdb- sysdtspackagelog, sysdtssteplog, sysdtstasklog.

    Is it possible?

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

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