I need your small help regarding my approach..
Coding in :- VB.net
I have an web application(Changepoint a tool for project management) whose database is in mssql they have provided us the web service API's by which we can load the data into their database.
e.x. suppose we want to add the resource information i.e. name, payroll and the stuff like this...
we have to pass these values to the api and the api will do the rest.
We will receive a CSV file containing the info of resources...
my approach is ....(please correct me in this)
1> i will load the data into a temp table.
2> from my own created vb.net application ill read the data from that temp table with the help of datareader and pass it to the API's.
There will be no updation/insertion and deletion on the temp table.
am i going in the right direction ?
or there can be a better solution to this..?