Yes -- the same DB and Table. I have the PHP running in one window and I simply print
out the query and paste it into SSMS, where it then succeeds without a hitch.
The ORIGINAL source of the data is, in fact, an Excel file in CSV format. I have problems
with all sorts of field types, tho' -- text-to-text, date-to-date, integer-to-integer.
I was THINKING that I have corruption in the metadata and would like to know how to check
that and repair it.
in ANY event, I'm stuck with this data, and I really need to be able to insert new stuff into
it, so ANY help would be appreciated. ( Perhaps there's a way to "force" the insert through some
conversion or other operations??? )
Mark
************************************
In SSMS, does the query insert into the same target?
I've seen SSIS have problems like what you're describing, because of different datatypes in the target than in the source. Like Excel, which wants all the string type columns to be unicode instead of ASCII.
- GSquared
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon