• Attached to this post is a simple SSIS Package * that will load your file to (a slightly modified version of) your POMaster table. I think you will need some transforms to resolve some of your data points to system keys, e.g. the Purchase Order # in your file is alpha-numeric and in your table PONum is declared as an INT, but you'll get the idea. The intent was to show you how to setup an SSIS Flat File Connection Manager to parse a delimited file with text qualifiers and embedded delimiters.

    * the forum would not allow me to attach a file with a .dtsx extension, so I named it with a .txt extension, just drop the .txt on save.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato