Post reply

bcp Utility Question

  • March 3, 2022 at 9:58 pm

    #3992709

    Basically you'll need to use a format file that maps the fields from your source file to the specific columns in the target table if the number/order of columns isn't exactly the same.  This should get you the base 1 to 1 format file for your table for a comma delimited input.  You'd need to modify that to match your file to the table.

    bcp <table> format nul -f <format file name> -S <server> -T -d <database> -c -t ","

     

    But if you want to avoid balding and grayness, try SSIS instead.

  • March 3, 2022 at 10:55 pm

    #3992728

    Thanks for the quick reply.  I'll give this a try and see how it does.  Much appreciated. Personally not sure why we don't use SSIS on this, but that's out of my area.  If I had anything to do with it, I would definitely do it 🙂

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply