Test Data Manager

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.

How much data are we talking? Bulk copy may be overkill. 

If the data in question isn't huge, we can do a 'for each row' with a query inside it to insert that record into the db.

In the meantime, can you offer me some more details and I will try to build an example using the bulk copy activities.

Okay, turns out this is fairly easy, I have uploaded an example with a word doc here: 

http://grid-tools-downloads.com/matty/CSVIntoDatatable.zip 

You do it by creating a data reader directly from the CSV like so:

Kind regards,

Benjamin.

Thanks Benjamin for response. I am trying to open the Javelin workflow you have attached but on opening the file , I am not able to view all activities as it gives error "Activity could not be loaded because of errors in XAML".

 Could you please resend the javelin flow document. thanks !

Regards

Shivani

Can you send me a screenshot? of the entire window (so I can see your version number too). You're probably on an older version of Javelin than me.

I'm not quite sure why you can't see it on your version, but actually, it doesn't matter- the smart stuff you want to look at so you can do the same in your flow is all inside 'Append to Table' anyway.

Have a look in there and you should see this:

I am not able to see Idata reader push to sql activity , could you send the screenshot of its properties. thanks for your patience 

So that activity is just a renamed SQL bulk copy activity, which is referring to the  IDataReader produced by our assign block, (usually produced by the data reader activity).

Thanks. I had figured it out. Thank you !!

Shivani,

Any Idea what was wrong with this ? and How to got it. I see the same error in one of my Javelin flows.

Hi

Sorry for being late. But the error I was facing because of variable and type of variable being passed. Below is the flow which i used to get it working. CreateDataReader function was used.