J Livingston SQL (7/18/2014)

---

halifaxdal (7/18/2014)

---

Here is the format file, .xml is changed to .txt to get uploaded on this forum. Thanks.

I think the issue is the last column, like I indicated in previous post, the last column is NOT a width fixed column, in some cases it is 0, in some cases it is a big number

BTW: I have posted both my test data and format file here in this thread, everyone can you please try them out on your environment, thank you very much.

hi Halifax...I am no bcp expert...far from it.

however, and for what its worth....I could import your test data using SSIS import wizard with ragged right format on the flatfile data source.

regards