Thanks

I used ssis xml task xpath the original file was of the following form

______________

My input file has the following format

<enterprise>

<person>

<sourcedid>

<source>111111</source>

<id>22222</id>

</sourcedid>

<name>

<fn>xxxxxxx</fn>

<n>

<family>yyyyy</family>

<given>zzzzzz</given>

</n>

</name>

<demographics>

<gender>2</gender>

</demographics>

<email>xxxxxx@fffff.edu</email>

<adr>

<street>cccccc</street>

<locality>ccccc</locality>

<region>cccc</region>

<pcode>ccccccc</pcode>

</adr>

<academics>

<academicmajor>gggggg</academicmajor>

<customrole>hhhhhh</customrole>

<customrole>dddddd</customrole>

<customrole>cccccc</customrole>

</academics>

</person>

<person>

…

</person>

</enterprise>

______________________

out put was in the form of

<ResultRootNode>

<fn>...

Any solution for that

Thanks

here is my target table structure

UserIDintUnchecked

Emailnvarchar(50)Unchecked

Passnvarchar(20)Unchecked

FirstNamenvarchar(20)Checked

LastNamenvarchar(40)Checked

DisplayNamenvarchar(50)Checked

Profilenvarchar(MAX)Checked

DisplayEmailnvarchar(50)Checked

CellPhonenvarchar(20)Checked

UpdatedByintChecked

UpdateDatedatetimeUnchecked

DeletedbitUnchecked

where email is unique

Thanks again

Thanks Now I need to add the ones which were not inserted into a log table with the same columns

I tried the following but it did not work

create table...

Thanks I will try the merge and I might come back to you if I got a question. Thanks again

yes

<?xml version="1.0" encoding="UTF-8"?>

<enterprise>

<person>

<name>

<fn>Lee Terence</fn>

<n>

<family>Lee</family>

<given>Terence</given>

</n>

</name>

<email>tlee11@xyz.com</email>

</person>

<person>

<name>

<fn>John Jack</fn>

<n>

<family>John</family>

<given>Jack</given>

</n>

</name>

<email>JohnJack@xyz.com</email>

</person>

<person>

<name>

<fn>Lee Terence</fn>

<n>

<family>Lee</family>

<given>Terence</given>

</n>

</name>

<email>tlee11@xyz.com</email>

</person>

<person>

<name>

<fn>Mary Luiz</fn>

<n>

<family>Luiz</family>

<given>Mary</given>

</n>

</name>

<email>MayLuiz@xyz.com</email>

</person>

<person>

<name>

<fn>Hani Safwat</fn>

<n>

<family>Safwat</family>

<given>Hani</given>

</n>

</name>

<email>HaniSafwat@xyz.com</email>

</person>

Thanks

I have a duplicate email intentially.

Can you explain more how to shredded down. Performance is very important because the xml files are of size 1g

Thanks

Thanks

around 600 xml files each day of size 2 k each

Thanks