Last post Jan 07, 2015 09:36 AM by supermannum1
Jan 01, 2015 05:32 AM|supermanNUM1|LINK
I want to feed xml files which under folder to SQL. I used ssis and can feed all xml.
But it goes insert as new data. When i want to update how should i do that.
Even if I want to delete data, how to do that with xml and send to sql.
please any advice.
Jan 02, 2015 12:59 AM|Edwin Guru Singh|LINK
For your information, Please check the following link which can be guide you to fix your case :
Jan 02, 2015 01:54 AM|supermanNUM1|LINK
My problem is,
I have a folder which has several xml files to update database. I use ssis to feed xml into sql table. I can successfully feed xml into sql.
But update command, update xml , i do not know how to feed xml and change expression for them.
My overall solution is
- 1 - feed xml files which include insert, update, delete for sql table into sql
- 2- delete xml files after successful processed
Please kindly advice or any sample, i am very new to SSIS
Jan 07, 2015 09:36 AM|supermanNUM1|LINK
solved with above link