I'm working on a project where I need to export some invoicing data from our database to a file. The format of the file needs to be EDI 210.
I'm looking for a starting point. I've looked at:
- ETL tools which seem to be a bit much for this one specific task
- Building the file from withing Visual Studio C# / using a SQL connector, but this may take a long time
- Doing the translation in SQL via sp, again a long process.
- Writing it to XML in a stored procedure and then using an XML > EDI tool. These seem to be more popular than the Database > EDI tools.
I'm hoping someone here knows of some base I can work from so I don't have to do it from scratch.
SQL Server Ent 2000