Can someone please help.
I have a dataset that is populated with a csv or a tab seperated txt. I get the datset fine but when I try to insert into a table in sql with bulkinsert I am getting an exception.
The table does not allow nulls in the column. So what I need help with is scanning the dataset for a null value and replacing with an empty string or int value.
I spent some time looking around and found some code that will testif a column has a null value but I cannot seem to find the values and replace them.
Any help would be appreciated.
I will post some code a little later, just not on my work computer right now.
Thanks in advance