Last post Jan 23, 2017 06:42 AM by Chris Zhao
Jan 19, 2017 07:15 PM|Jay.NET|LINK
I'm trying to decide the best tech to use to do what I need.
I need to have a scheduled task/service that does the following...
Make a call to a JSON webservice.
Take a value from that return ( a token) and use it in a call to a different JSON webservice.
Take the dataset returned from that call, manipulate the data and pass values to a stored procedure for table inserts.
On the face of it, it sounds like a job for an SSIS package but I'm finding JSON support in SSIS to be sketchy. Even looking at 3rd party extensions.
Would this be fairly easy to achieve with ASP.NET or should I persevere with SSIS?
I've found a couple of articles/tutorials online where SSIS is used to get JSON using the scrip task but they are dated and the code used isn't recognized by Visual Studio 2015 e.g. Variable.MyVarName (to reference a package variable) in the script editor
Jan 23, 2017 06:42 AM|Chris Zhao|LINK
If you need to run tasks on a schedule as part of your ASP.NET application, see