Link to home
Start Free TrialLog in
Avatar of tommyo94
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.
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

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.
This would be done at the application (presentation layer) and not in SQL Server itself.
Avatar of tommyo94
tommyo94

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.
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
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial