AnsweredAssumed Answered

Javelin Flow - Export Excel contents to database

Question asked by shivanikaul on Feb 9, 2017
Latest reply on Apr 11, 2018 by shivanikaul

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.

Outcomes