To find how to change the number of columns in the package.
Create another export package to export a table with two columns to a csv file with headers and quote delimited data items.
View the xml to identify the changes needed to add columns to the package.
Ignore the items that define the database, table, filename just look at the items that define the columns.
These can be identified by having an entry for c001 and c002.
create table ExportTest_c001c002 ( c001 varchar(20) , c002 varchar(20) ) go
DTS:ConnectionManager: DTS:ObjectData: DTS:ConnectionManager: DTS:FlatFileColumns: Then DTS:FlatFileColumn for each column inputs: input: inputColumns: Then inputColumn for each column externalMetadataColumns: Then externalMetadataColumn for each column outputs: output: outputColumns: Then outputColumn for each column externalMetadataColumns: Then externalMetadataColumn for each column Note: the following block is the error handling output: outputColumns: Then outputColumn for each column