Problem:
I need to know the affected rows by the bulk insert task. In my DTS package
I tried to have the ActiveX Script or Exec SQL task to fetch the rowcount
after insertion. But in my scenario there would be simultaneous packages
running sometimes against the same table. Due to which I get different
record counts, rather than actual rowcount done by one Bulk insert.

Is there a way like properties to get hold of affected rows after bulkinsert
completion.

--
Thanks
SatishTL

Only if you use the DataPump task, the Bulk Insert Task does not have any
such property.

Another alternative would be to wrap the BulkCopy in code and capture the
RowsCopied event which has a suitable parameter.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"SatishTL" <SatishTL (AT) discussions (DOT) microsoft.com> wrote

Thanks Darren, but I have to go for Bulkinsert task as the volume of data
being inserted through some of the files are in 1.5Gig sizes. I belive
DataPumptask takes longer duration for such huge files.

- SatishTL

"Darren Green" wrote:

DataPump is slower, but if configured properly it will be very close. What
is the cost of counting rows some other way vs the drop in perf? Make your
choice.

The DataPump will use the same fast load API under the covers, and by
setting optimal batch and buffer counts you can dramatically increase
performance.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"SatishTL" <SatishTL (AT) discussions (DOT) microsoft.com> wrote