April 15, 2015 at 8:25 am
Hi There,
is there any way to have a row count from Bulk Insert Task, like we do for data flow task?
Thanks In Advance
April 17, 2015 at 7:42 am
Hi
I'm afraid not, you can count rows in separate tasks before and after run Bulk Insert Task.
Br.
Mike
April 17, 2015 at 7:48 am
Might as well use a data flow ...
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
April 23, 2015 at 1:55 am
vignesh.ms (4/15/2015)
Hi There,is there any way to have a row count from Bulk Insert Task, like we do for data flow task?
Thanks In Advance
Try using the @@ROWCOUNT global variable.
BULK INSERT foo
FROM bar
GO
SELECT @@ROWCOUNT
____________________________________________________________
APViewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply