How to use XML data of SQL table column and perform tasks based on tag values.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » How to use XML data of SQL table column and...

How to use XML data of SQL table column and perform tasks based on tag values.

Rate Topic

Display Mode

Topic Options

Author

Message

connect.akshay

Posted Wednesday, March 20, 2013 11:04 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, May 12, 2013 7:01 AM
Points: 17, Visits: 102

Hi Guys.

I need some help. I am suppose to get XML data from column of a table. The XML data has many tags. One of the tag contains values like
<Code date= 30/03/2013>
<apr id =1> -2 </apr>
<rdv id =2> 1 </rdv>
</code>

I need to run a particular task which checks the date. Like if today's date= (Code date -2) or
today's date = (code date + 1)
run a mailer task.

How should i go about it ? Please forgive me for the XML data format. I am naive in XML.

Post #1433350

connect.akshay

Posted Friday, March 22, 2013 12:34 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, May 12, 2013 7:01 AM
Points: 17, Visits: 102

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

Post #1434144

« Prev Topic | Next Topic »

Permissions