how to export data from database tables to an xml file using ssis?
['Send data to a RecordSet destination.', 'Use a script task to convert the RecordSet into a DataTable object.', 'Use the DataTable. WriteXML() function to export the XML file.']