Extract Data in EDI file format

[ptheriault]

Has anyone worked with EDI files? What is the best way to extract a file in EDI format from SQL Server 2005.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[philhege]

Well. It depends on what your trading partner is using for EDI format. Not everyone hews to the standard. I'm wrestling 856s right now; fun wow.

Since you're using SQL 2K5, there's probably a ton you can do with XML query returns. But nothing native or canned (that I'm aware of) will create an EDI file painlessly; you'll have to do the work to format the output.

If you have Biztalk, there's a mapping device that can transform output based on document specifications (like X12). That is, if you have BT2002 or earlier; MS ripped the X12 support out of later versions.

Have fun!

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[ptheriault]

Thanks Phil,
I think I'm going to look into Biztalk.

- Paul
- If at first you don't succeed, find out if the loser gets anything.