First post for me so hi to all :)I'm consuming some web service stuff in SSIS and have got stuck with an issue that I thought would take minutes to resolve... I was wrong.
I'm an SSIS / SQL developer so only get mixed up in vb.net when SSIS isn't able to do what I want with native functionality so I'm coming to you as a very novice novice.
[code]
1234
1
[/code]
I need to get the two values from the 2 elements into 2 string variables. Sounds simple yes. I can do this in SQL in seconds so thought it would be a few minutes work yet hours later all i've managed to do is to using xmlreader pop up a messagebox displaying 'root' then 'SrqNo' then '1234' then 'SeqNo' then '1'...
very pretty but gets me nowhere.
* In my code the above xml will come from a string variable not a document.
* I want to use intended xml functionality as in future packages the xml may be more complex.
* I need to end up with 2 string variables; the 1st containing '1234' and the 2nd containing '1'.
Simple as that?
Cheers guys
Comments
Check out this forum thread for how to pass a string to the XMLReader object... http://social.msdn.microsoft.com/Forums/eu/xmlandnetfx/thread/2aad018f-7af1-41c3-bfa1-8691eed0eb38
You should be able to find ample tutorials with a simple google search. If you are still having problems, you can email me directly (find my contact information in the Sticky Thread I stuck up top of this forum).
Happy coding,
Sean Campbell - Firesickle