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 ...
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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