Could you have the package create all of the files, then iterate back through an push the file to the appropriate drive (based on information stored in a table perhaps)? I...
You need to pass in the numerical equivalent. Those values are defined in adovbs.inc include file which is not included in the ActiveX task. Use the numerical equivalents.
You can generate a document using INFORMATION_SCHEMA.COLUMNS, using the FOR XML method. For this to work successfully, this can be quite the pain, especially to include a root element.