EDI file - generate using SQL?

Can an EDI file be generated using SQL 7 or SQL 2000?
I need to be able to generate EDI files based on data from an SQL table.What are the formats for an EDI file. Methinks you need DTS.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"niv" <niv@.discussions.microsoft.com> wrote in message
news:64BE6736-CBFF-4EAE-BF11-A6799EA1B996@.microsoft.com...
Can an EDI file be generated using SQL 7 or SQL 2000?
I need to be able to generate EDI files based on data from an SQL table.|||Yes it can, but it is better done client side using ADO, and even better
using BizTalk. Have a look at the FOR XML predicates for an idea of how to
do this. Its not for the faint hearted or weak kneed to do this in SQL
Server.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"niv" <niv@.discussions.microsoft.com> wrote in message
news:64BE6736-CBFF-4EAE-BF11-A6799EA1B996@.microsoft.com...
> Can an EDI file be generated using SQL 7 or SQL 2000?
> I need to be able to generate EDI files based on data from an SQL table.|||Hi Tom,
By format, do you mean ANSI X12 or EDIFACT?
I was initially leaning towards DTS but I am unsure how to map headers that
are in the EDI file with data coming out of SQL.
I read somewhere that Biztalk has the ability to do this, unfortunately I do
not have access to this tool.
If DTS can do this, please point me to an article that explains this process.
Tom, thanks for getting back to me.
"Tom Moreau" wrote:
> What are the formats for an EDI file. Methinks you need DTS.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "niv" <niv@.discussions.microsoft.com> wrote in message
> news:64BE6736-CBFF-4EAE-BF11-A6799EA1B996@.microsoft.com...
> Can an EDI file be generated using SQL 7 or SQL 2000?
> I need to be able to generate EDI files based on data from an SQL table.
>|||I don't know of any article per se but I do know that DTS is very capable -
and its SQL 2005 descendant, SSIS, is even more so. Clearly, you'll be
looking at Data Pumps with transforms. Perhaps if you posy a question in
the DTS newsgroup re EDI, you may get someone who has already done this.
Also, check out www.sqldts.com and www.sqlis.com.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"niv" <niv@.discussions.microsoft.com> wrote in message
news:1CDBD9EC-2EE7-4651-9450-3BAB5F579971@.microsoft.com...
Hi Tom,
By format, do you mean ANSI X12 or EDIFACT?
I was initially leaning towards DTS but I am unsure how to map headers that
are in the EDI file with data coming out of SQL.
I read somewhere that Biztalk has the ability to do this, unfortunately I do
not have access to this tool.
If DTS can do this, please point me to an article that explains this
process.
Tom, thanks for getting back to me.
"Tom Moreau" wrote:
> What are the formats for an EDI file. Methinks you need DTS.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "niv" <niv@.discussions.microsoft.com> wrote in message
> news:64BE6736-CBFF-4EAE-BF11-A6799EA1B996@.microsoft.com...
> Can an EDI file be generated using SQL 7 or SQL 2000?
> I need to be able to generate EDI files based on data from an SQL table.
>|||"niv" <niv@.discussions.microsoft.com> wrote in message
news:64BE6736-CBFF-4EAE-BF11-A6799EA1B996@.microsoft.com...
> Can an EDI file be generated using SQL 7 or SQL 2000?
> I need to be able to generate EDI files based on data from an SQL table.
You have guts!
I'd say in 2005 it's much easier then 2000. I did a snarl of EDI two years
ago with maintaining multiple DC's for multiple MFGs.
I never got to try BizTalk, but they say it's now able to parse EDI easily.
other issue is dates need ' ' for use in SQL server, so using a processing
class to extract what will be pulled or manipulated in the db is the way to
go. Then you have that same class write out the lines you need in your
replies.
__Stephen