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
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
Code (stored procedure) to output table export package XML
home