Tasks in DTS Package

  • My suggestion is to enable logging in the package then examine the log. The log records are recorded in the order they're executed as the package runs.

    Enable package logging by opening the package, selecting package properties, and setting logging on the "Logging" tab. A package can log to either SQL Server or to an error file. If you decide to log to SQL Server, run this query in msdb:

    select p.*,l.*

    from sysdtspackagelog p join sysdtssteplog l on p.lineagefull = l.lineagefull

    where p.name = 'whatever your package is named'

    Greg

  • Thanks a lot... we had log in the dts and I was able to run your query for last run and that at least gave me task numbers that ran in order... thanks!

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

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