Consuming web service and transferring data to database using SSIS
I have consumed simple web service to add numbers via SSIS and now I have
saved the output into xml file which I have stored on my local drive, now
I have to access that added result from xml file through XML DATA FROM
VARIABLE access mode and store that result in sql database via SSIS,
When I am trying to do this ,XML source is unable to take the inputs and
connect to OLEDB destination, actually I have also created user defined
variable but don't know how to use that variable since that variable does
not appear in the dropdown option of XML location of XML editor.
Any help will be greatly appreciated, since I am newbie to SSIS.
No comments:
Post a Comment