Find All Fields with missing or null values while loading a csv file

[#1]

Hello Everyone,

I have a csv file which has some fields with missing values and I want to identify which all fields have missing values. I can also use as stored procedure to get the same content as of the excel file.

Can anyone suggest how I an achieve this using either CSV file or stored procedure.

I started with the following code using stored procedure.

OLEDB connection;

load *;

SQL ****** EXEC Stored procedure syntax*************;

But in the above syntax all null values disappear from the fields.

Thanks in advance.

[#2]

Hi,

Can somebody help

I need to find all the fields which have missing values while loading from csv file.

Thanks in advance