Exporting Data Using BCP

Bradley Schacht

Bradley Schacht is a Cloud Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Administration". As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as SQLServerCentral.com and an active member of the Jacksonville SQL Server User Group (JSSUG).

You may also like...

3 Responses

  1. Stephen says:

    BCP is a great forgotten jewel. One limitation I have run into, is the limit to the size the query can be.

    • I agree, it is often overlooked. I’m guilty of that myself sometimes.

      In order to get around some of the issues with the command line I generally like to either put the logic into a view or of the logic is too complex for a view then use a stores procedure. You can ertainly use the queryout option and just run exec storedprocedure ‘parameter if necessary’.

      I’m doing that exact thing right now for a client to bring over change data capture queries to another server. So far it’s working out great.

  2. Scott says:

    Your queryout example made the day for me 😉

    I had been getting the quite useless bcp errors….

    Thank you, thank you!

Leave a Reply