tommyo94
asked on
SQL 2005 need to generate XML per each new record
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.
ASKER
So in the export from SQL server you cannot name the XML export with the value of one of the fields?
So in the export from SQL server you cannot name the XML export with the value of one of the fields?
What do you mean by export? Do you mean SSIS? If so, absolutely, SSIS is your application (presentation layer) and are at liberty to do whatever you can in that environment.
What do you mean by export? Do you mean SSIS? If so, absolutely, SSIS is your application (presentation layer) and are at liberty to do whatever you can in that environment.
ASKER
SSIS is what I am using. I'm not sure what commands to issue to modify the naming of the XML output file .
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This would be done at the application (presentation layer) and not in SQL Server itself.