DTS

• Desiree Jerrick

  SSC Journeyman

  Points: 82

  More actions

  May 16, 2007 at 11:28 am

  #117109

  How do I display the number of rows affected by a delete or update operation done through a DTS package. I have tried to set a @variablea  = to @@rowcount after the execution of the delete or update operation, and then

  select 'number of rows deleted = ' @variablea, but my select is ignored.

  Any ideas?  

• Ben Sullins-437405

  SSCertifiable

  Points: 5397

  More actions

  May 16, 2007 at 11:40 am

  #706897

  Where do you want it to be displayed? You could create a log table and insert the data in there and have it for reference later...

  ---

  Cheers,

  Ben Sullins
  bensullins.com
  Beer is my primary key...

• Desiree Jerrick

  SSC Journeyman

  Points: 82

  More actions

  May 16, 2007 at 12:00 pm

  #706907

  I would like to display it on the out put from the package execution: This is what I currently receive

  ****************************************************************************************************

  The execution of the following DTS Package succeeded:

  Package Name: Test Trigger_Delete

  Package Description: test 

  Package ID: {2264B686-0291-460F-8080-C409E0A03264}

  Package Version: {66761AE6-83E4-49D1-8D65-AD23480AA75C}

  Package Execution Lineage: {78D5E102-7CF5-46AF-96B5-42267346E7FC}

  Executed On: xxxxxxx

  Executed By: jerrickdh

  Execution Started: 5/16/2007 12:48:38 PM

  Execution Completed: 5/16/2007 12:48:45 PM

  Total Execution Time: 6.953 seconds

  Package Steps execution information:

  Step 'DTSStep_DTSExecuteSQLTask_1' succeeded

  Step Execution Started: 5/16/2007 12:48:38 PM

  Step Execution Completed: 5/16/2007 12:48:45 PM

  Total Step Execution Time: 6.812 seconds

  Progress count in Step: 0

   

• Carlos Urbina

  SSCommitted

  Points: 1850

  More actions

  May 17, 2007 at 8:49 am

  #707167

  I've taken the way suggested by Ben Sullins. The selected count does not go into a local variable but into a global variable specified as an output parameter. In a subsequent step I insert that global variable into a table, where it is available for post-package processes.