Hello, I'm using bcp insertion with ODBC from memory variables, but my code
is for customer databases that can add his own columns to every table. When
people add extra columns to the tables where I do the insertions by bcp, the
bcp_sendrow call fails. I've tried the control option BCPKEEPNULLS but it
doesn't work because I think that it can be used only for insertions from a
file.

There is a way to tell to the bcp process that no specified columns must be
set to NULL?

Thanks in advance.

Jorge.

See if this helps you
http://www.nigelrivett.net/SQLTsql/ImportTextFiles.html

Madhivanan

Create a view over the table and BCP into that. All the excluded
columns must be nullable or have defaults.

It works fine.

Thanks a lot.

Show quoteHide quote

Dynamic WHERE & Dates
with(updlock) - How many times on same table in single update?
Composing a date from date parts
Delete Query ?
query metadata within trigger scope