Issues with bcp utility for loading data from file to table RRS feed

  • Question

  • Hi,

    This question might look generic but, I am facing issue with loading data from a file delimited with character § into a table using format file. I have to use format file because there are around 15 columns in the target table which need to be skipped. All these columns are towards end of the table. 

    While I took help from the forums and the articles provided by msdn, I am still facing issue and unable to load the data from file to table. It is neither giving any error nor loading data into table. The format file which I was using is the one which is generated using the option mentioned with format nul.

    Request you to share your experiences/reference blogs which guide in handling such scenarios using bcp.



    Phaneendra Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.

    Tuesday, November 5, 2019 5:59 AM

All replies