Row count in Bulk insert task

• vignesh.ms

  Hall of Fame

  Points: 3456

  More actions

  April 15, 2015 at 8:25 am

  #316646

  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

• michal.lisinski

  SSCertifiable

  Points: 6933

  More actions

  April 17, 2015 at 7:42 am

  #1791675

  Hi

  I'm afraid not, you can count rows in separate tasks before and after run Bulk Insert Task.

  Br.

  Mike

• Phil Parkin

  SSC Guru

  Points: 246960

  More actions

  April 17, 2015 at 7:48 am

  #1791679

  Might as well use a data flow ...

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin

• SQL.AP

  Hall of Fame

  Points: 3244

  More actions

  April 23, 2015 at 1:55 am

  #1792943

  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

  ____________________________________________________________

  AP