how to get the number of rows exported through bcp

• Karthika Raman

  SSCrazy

  Points: 2520

  More actions

  July 30, 2007 at 2:54 pm

  #197123

  Hi,

  I need to be able to output the number of rows exported through bcp to another file.  Is there a simple way to do this?

  The current code is as follows:

  DECLARE

  @sql varchar(8000)

  SELECT

  @sql = 'bcp "exec stored procedure" queryout Drive:\path\output.csv -T -c -t,'

  EXEC

  master..xp_cmdshell @sql

   

  Help is greatly appreciated

  KR

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  July 31, 2007 at 1:33 am

  #723488

  There's no real nice way I know of because it is a process outside of SQL.

  You could do a count on the table but this could be slow.

  You could also insert the results from the XP_CMDShell into a table and grab the rows from there. Will have to do some string manipulation to do this though.

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

• Karthika Raman

  SSCrazy

  Points: 2520

  More actions

  July 31, 2007 at 8:47 am

  #723609

  That is what I was afraid of.

  Thanks

  KR