I have a javelin flow wherein I need to export the contents of an excel file to data mart table.
I have created "ReadCSVToDataTableActivity" activity which is creating a data table as output.
Then I have created "SQL Bulk Copy - Data Reader" to copy the contents of data table to data mart table (Sql Server).
But, I get error "Object reference not set to an instance of object".
is there anything specific field to be mentioned in properties of data reader/bulk copy to achieve the desired results. Please help.