We all know that SSIS can take an XML source and convert it to rows & columns
for processing in a Data Flow.

But is there any way to take rows and columns from a SQL command and
transform that into an XML string.

The only ays I know would be to

1. Return XML from the SQL Command and bind it to s string variable.

2. Use a DataFlow component to right to an ADO Recordset destination which
is bound variable, then write a script to loop through the Recordset variable
and create an XML string.

Anyone else know of better ways?

Thanks,
Dave.