Last post Jan 07, 2015 12:17 AM by supermannum1
Jan 05, 2015 11:12 AM|supermanNUM1|LINK
I can feed xml to insert new record into database using ssis.
But i do not have any idea and lack of ssis experience to update database with xml feed.
I tried to use Execute sql task after for each loop and doesnt work.
Jan 06, 2015 05:09 AM|Nasser Malik|LINK
Follow tutorial for bulk import through XML
import XML into SQL Server with the XML Bulk Load component
and also see following helping materials
Importing and Processing data from XML files into SQL Server tables
Importing XML documents using SQL Server Integration Services
Jan 07, 2015 12:17 AM|supermanNUM1|LINK
This is the link can sort my problem.
Can insert if data is new, if not can update