Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jonathan Kehayias Trading in xp_cmdshell for SQLCLR (Part 2) - Export Data to Flat Files RE: Trading in xp_cmdshell for SQLCLR (Part 2) - Export Data to Flat Files

  • June 18, 2011 at 12:46 pm

    #1340812

    noeld (3/4/2009)

    -- Cranfield (3/3/2009)

    How does the performance compare to native BCP OUT? should it be the same.

    cheers

    BCP should OUTPERFORM this by far.

    The problem is that it is NOT as flexible and controlled as when you know what the code can or cannot do.

    Sorry, a bit late, I know. I am just wondering: is it possible to start BCP using CLR instead of xp_cmdshell? That would combine the best of both worlds ...