<div>
<i>I'm not sure where this would be done and we need to name each XML file with the incident number which has its own field.</i><br />
This would be done at the application (presentation layer) and not in SQL Server itself.
</div>


<div>
So in the export from SQL server you cannot name the XML export with the value of one of the fields?
</div>


<div>
<i>So in the export from SQL server you cannot name the XML export with the value of one of the fields?</i><br />
What do you mean by export? &nbsp;Do you mean SSIS? &nbsp;If so, absolutely, SSIS is your application (presentation layer) and are at liberty to do whatever you can in that environment.
</div>


<div>
SSIS is what I am using. &nbsp;I'm not sure what commands to issue to modify the naming of the XML output file .
</div>


<div>
<div class="content wysiwyg-content">
We are currently running SQL 2005. &nbsp;We need to generate an xml file as each new record is entered into the database. &nbsp;I'm not sure where this would be done and we need to name each XML file with the incident number which has its own field.
</div>
</div>


We are currently running SQL 2005.  We need to generate an xml file as each new record is entered into the database.  I'm not sure where this would be done and we need to name each XML file with the incident number which has its own field.

SQL 2005 need to generate XML per each new record

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.