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.

Since I was unable to get the rowcount value from the bulk insert TSQL command in a DTS Execute SQL Task, the alternative I used was to dynamically configure the SQL Statement at runtime with a VBscript and the global variable value of the number of rows that should have been inserted. So the task ends up as:

BULK INSERT (table)
               FROM '(file)'
               WITH (FIRE_TRIGGERS,
               FORMATFILE = '(formatfile)')
               IF (34693609=@@ROWCOUNT)
                    BEGIN
(misc)
                    END
               ELSE
                    BEGIN
                         (misc)
                    END

You wouldn't still happen to have a sample of the script you wrote for this would you? If so I would love to get a hold of a copy as I am in the depths of this right now and could use a hand.

Thanks,
Rich