Capturing rows inserted from bulk insert

Is there any way to capture the count of rows processed by a bulk insert task
A property perhaps
I can run queries post import but would prefer it if there was a way to capture that number directly. It was something we had in the old DTS as the package ran. Anything we can do to discover it in SSIS

Paul Pisarek

Answer this question

Capturing rows inserted from bulk insert

Emran Hussain
One option is to enable the out-of-box logging to sysdtslog90 table - the components displays number of rows processed. It's in the 'message' text colum though, so you need to add a little bit of parsing to get your specific data.

KDog
CharlesY
That's right. We're working on a sample that parses the string and creates a report from it, hopefully should be available to you soon. But, yes, parsing the log is the right approach.
Capturing rows inserted from bulk insert

Answer this question

Capturing rows inserted from bulk insert

Hot Topic

SQL Server

Capturing rows inserted from bulk insert

Capturing rows inserted from bulk insert

Emran Hussain

CharlesY