The value is a datetime2 type . SSIS doesn't support datetime2 .You need to store it in database as string and then update the column by converting it to datetime2.

Here...

I wasn't able to upload the screenshot here. So created another thread. Please see ..

http://stackoverflow.com/questions/16161774/xpath-find-parent-attribute-using-child-condition

MM

The forum is correct. I was using an XML task in SSIS. My requirement was the earlier one where I wanted to find the First-name.

I thank you for your...

I got the solution but it needs some modification:

I am able to get those values using ancestor keyword but the result is coming out as a concatenate.

Result now : Noveltextbook

Desired...

that was the question. I am not able to extract those values.

It's like finding parent id depending on child conditions.

//book/author/award[.="Pulitzer"]/style doesn't work as exepcted. Could you please tell the...

Thank you for your suggestion. How can I do the vice-versa ?

I mean I would like to find which style of book is it whos author has won the "Pulitzer...

We can use the below condition if we want to find the first-name.

//book[@style='novel' and ./author/award/text()='P']//first-name

Any better answer is deeply appreciated.Thanks for viewing my question though.

Thanks Atif for sharing your knowledge. I am not able to grasp the ERRORFILE argument addition. Could you please elaborate of how to use it ? I am new to...

Praveen posted a solution for this.

http://stackoverflow.com/questions/15529842/how-to-use-xml-data-of-sql-table-column-and-perform-tasks-based-on-tag-values

Thank you all for suggesting your solutions. Use of a staging table would definitely help.

As the number of columns are less, I applied a different solution.

Insertion was done as I...

I could have. But it is not a Staging table. It is main table, acting as a main repositry.

Anyway I did make a partial solution for the problem.

We need to...

3 errors are coming for 1 file.

I want to make sure that the loop goes on executing even if the processing of one of the files fails.

Also I want to...

it's just a custom error that i am populating using the script task on the 'ONERROR' handler of the Loop. The problem is, it is getting populated 3 times.

Attached is...