Bulk Insert TSQL in DTS – Rows Affected Count -
09-06-2005
, 04:17 PM
I have a TSQL bulk insert command in a DTS package as an Execute SQL
Task because I need to have triggers fired on the table as the data is
inserted. I wish to know if there is a way to have the total number of
rows inserted to be returned so I can put it in a variable? I was hoping
this would be stored in msdb.sysdtssteplog as progresscount but it is
not.
I am interested in comments and/or suggestions.
*** Sent via Developersdex http://www.developersdex.com *** |