Today it is a one-off. But I will be setting up a weekly process for future imports.

I thought I would use the wizard the first time, then save it as a package for future use.

There are probably some funky characters in the text strings that SQL doesn't like.

EDIT: There were some commas in one of the columns that i removed, and in one text box there was 3 pages of diatribe about the economy that had 8,900 characters. I modifed those, and the import worked, but a cumbersome solution.