home


SSIS Generic File Exporter 6 - Stored Procedure to produce export package XML
Author Nigel Rivett

Generic SSIS File Exporter 6 - Stored Procedure to produce export package XML


Objective

Stored procedure to produce export package XML This will use the package template together with the table structure and replacement data to build the XML


Method
	1. Inputs
		Export schema name
		Export table name
		File location
		Server name
		Export database name
	2. Get the structure of the table to export
	3. Build the export package XML in a temp table from Export_Package_Template and Export_Package_Template_Replace tables
	4. Produce the export package XML as output



Downloads

Code (stored procedure) to output table export package XML

home