Hi
A customer of ours has specified that we must supply invoicing information to them as as XML.
They have supplied a (very complex) DTD file which specifies the required format.
Our data is held in SQL 2000 databases. We also have SQL 2005 and Visual Studio 2005 (we use c#) at our disposal.
Could anyone suggest the most painfree way to tackle this project. I've read many threads about SSIS, T-SQL export, c# xml writers etc but I'm unsure which avenue to pursue.
Thanks
Wayne
A customer of ours has specified that we must supply invoicing information to them as as XML.
They have supplied a (very complex) DTD file which specifies the required format.
Our data is held in SQL 2000 databases. We also have SQL 2005 and Visual Studio 2005 (we use c#) at our disposal.
Could anyone suggest the most painfree way to tackle this project. I've read many threads about SSIS, T-SQL export, c# xml writers etc but I'm unsure which avenue to pursue.
Thanks
Wayne