DTS Statistics, after run

• PFlorenzano

  SSCrazy

  Points: 2120

  More actions

  December 12, 2003 at 8:16 am

  #107424

  Hello everyone,

  I have a question in regards to the post run of a DTS package. Lets say I run a simple package that updates a table. Is there a place in SQL Server where I can see how many records are updated? like in a text file somewhere as opposed to writing a query to see the expected results?

  Thank you,

  Peter

  Peter M. Florenzano
  
  Database Administrator
  

• philcart

  SSC-Forever

  Points: 47794

  More actions

  December 14, 2003 at 4:05 pm

  #486081

  How are you updating the table? Using a stored procedure in an ExecuteSQL task, you can return the value of @@ROWCOUNT to a global variable.

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface

• geomon

  Old Hand

  Points: 316

  More actions

  December 30, 2003 at 2:12 am

  #488137

  If you have Package Logging enabled, you can hit the sysdts* tables in MSDB. All the info you see in the GUI progress dialogs is buried in there.

  Happy New Year!