Is there a way to force a value(N/A) to a SQL field defined for NOT Null if the csv field is empty?

error

does not allow DBNull.Value.

very cool.. I'll run some test and report back results

 Thanks again.

Sounds good !!!!

Thanks.

"Creating specific datatypes for the datatable's columns is another exercise altogether, though I would do it by querying the schema of the table."

can you drop a example of...

Very nice script and useful. couple of questions
1) how could it show lines imported and records loaded to table for verification.
2)  how about records that fail can it...

Thanks.

How do you invoke the script -thanks

I was thinking of using VB/DMO approach.

There maybe a need to add/modify jobs.