Esqueleto


Hello

I have this small problem that I think that is easy to resolve, but I cant figure how.

In my table I have a column that will have a XML that it will be use as input in inserts and updated in my database.

How can I make this XML a Dataset in my DataFlow

I can load a XML from a file. Can I load a XML from a variable, or in this casa from a datatable column How

Hope someone could help me

tkx in advance

Paulo Aboim Pinto





Re: Import XML from a table column

Esqueleto


any one ! ! ! !






Re: Import XML from a table column

Rafael Salas

Can you provide more details about your scenario: tables, data, insert/update logic, etc







Re: Import XML from a table column

jwelch

Esqueleto wrote:

Hello

I have this small problem that I think that is easy to resolve, but I cant figure how.

In my table I have a column that will have a XML that it will be use as input in inserts and updated in my database.

How can I make this XML a Dataset in my DataFlow

I can load a XML from a file. Can I load a XML from a variable, or in this casa from a datatable column How

Hope someone could help me

tkx in advance

Paulo Aboim Pinto

You can load XML from a variable, using the XML source. So you could use an Execute SQL to retrieve a resultset containing your column, a ForEach loop to iterate each row and put the XML column into a variable. Then your data flow could use the XML Source to process the data.






Re: Import XML from a table column

Esqueleto

Hello

tkx for the reply.

Like I said I have a table with rows. Each row will be a operation to be performed in the database. The data to be executed are in one of the columns and it's in a XML format. For example if it's data from client, all the data are stored in XML in that fields.

One mecanism will get each row and perform the operation. Now the mecanism is StoreProcedure and I'm trying to change that to SSIS.

There is any way to put that XML (that is in a column of table) as a DataSet readable from XML Data Source

hope this help you helping me

tkx in advance

Paulo Aboim Pinto

Odivelas - Portugal






Re: Import XML from a table column

lasa

That will work well as long as you're working with a small number of rows, otherwise performance will be an issue. Another possible solution would be to export the xml-columns to a temporary xml structured file (using a FOR XML statement) that you could read using an XML source, which ought to be faster for a large number of rows.

/Lars