home


SSIS Generic File Exporter 4 - Configure Number Columns
Author Nigel Rivett

Generic SSIS File Exporter 4 - Configure Number Columns


Objective

To find how to change the number of columns in the package.


Method


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


I have separated these items in the file download at the end
There is the table definition, the file definition and the mapping between them

The blocks are in order they appear
	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



Downloads

Package: two column export

home