logging dts steps and results

[OhioSteve]

Okay, I have developed the most brilliant dts package in the history of the universe. It will run each day, and my users will rejoice.

I want to see how each step executes on each day. It would be nice to store this information in a text file or in a db table. For example, an entry might read "step 16 complete. tableA contains 100 records".

Does dts include anything like that already? I don't want to reinvent the wheel.

 

[jabrony76]

You can turn on Package Logging, right click the dts window and go to properties and enable package logging but it doesn't contain this level of detail.

Package logs will tell you what steps started, completed and their run-time, I belive.

To do this, to the level of granularity you describe, you would have to have each task log itself to a table using T-SQL upon completion and then create the text file, thus, re-inventing the wheel. Have fun Mr. Goodyear...

Andy