SSIS XML Insert to Sql 2008 database
-
Friday, February 15, 2013 4:39 AMI am using SSIS 2008 to insert data to a Sql 2008 database. The source of data is from a web server so I set up the web services task, xml task and the data flow task. For testing purposes I used the web services "Phone Verify" and I configured teh web services task with three variables, Row Count, PhoneReturn and PhoneVeriftResponse and the xml task with appropoate "input" and "output". So I set up the linkage staring from web services to xml and to data flow task. I also set up a break point inthe xml task so that I can see the values in the variable. I tested the web services and xml task and it worked and I can see the xml string coming back as the same way when verifying it over a browser. However on the data flow task I created a xml source task and configure it with the option xml data with variable and an OLE DB destinatin task connecting to a Sql database. However the xml source task I could not configure it to make it work. I wonder if I did something wrong
Kahlua
All Replies
-
Friday, February 15, 2013 3:15 PMModerator The XML source task appears to me needs to be set to consume the file that is getting deposited by the WebService Task, not the variable.
Arthur My Blog
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 7:22 AM
.png)
