Is there a way to create an XML destination in a data flow task?

I am trying to create an XML string to pass as a parameter in a web service.

You will have to craft your own using the Script transform as a
destination.

--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com



"Landry, Eric" <eric_landry (AT) tsged (DOT) com> wrote

I'm attempting to do that, but am not having very much luck.

I'm delivering a recordset destination variable to a script object, but it's
not working for me.

This is how I'm trying to fill a DataTable from the recordset:

Dim adaHeader As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter()
Dim tblHeader As DataTable = New DataTable("Header")
adaHeader.Fill(tblHeader, Dts.Variables("rstHeader"))

There is an XML destination adapter for SSIS available at http://www.keelio.
com

Matt Olson
http://www.keelio.com

url:http://www.ureader.com/msg/11463757.aspx

There is an XML destination adapter for SSIS available at http://www.keelio.
com

Matt Olson
http://www.keelio.com

url:http://www.ureader.com/msg/11463757.aspx

There is an XML destination adapter for SSIS available at http://www.keelio.
com

Matt Olson
http://www.keelio.com

url:http://www.ureader.com/msg/11463757.aspx

There is an XML destination adapter for SSIS available at http://www.keelio.
com

Matt Olson
http://www.keelio.com

url:http://www.ureader.com/msg/11463757.aspx

There is an XML destination adapter for SSIS available at http://www.keelio.
com

Matt Olson
http://www.keelio.com

url:http://www.ureader.com/msg/11463757.aspx

There is an XML destination adapter for SSIS available at http://www.keelio.
com

Matt Olson
http://www.keelio.com

url:http://www.ureader.com/msg/11463757.aspx

There is an XML destination adapter for SSIS available at http://www.keelio.
com

Matt Olson
http://www.keelio.com

url:http://www.ureader.com/msg/11463757.aspx