Need Help, EDI 834 for Newbies

[Dave Wilson]

Hi, the company I work for has CozyRoc already on two servers.  We have an additional task that would require it on two more servers, but I have to prove that it would work.  It is a simple EDI 834 load, but I don't have a suitable EDI 834 XSD file.  Does anyone have one they could post/loan me?

Thanks!

Dave

[Jeremiah Nace]

Dave,

Did you ever find an 834 XSD Meta file?

Thanks,

Jeremiah

[Ross Zimmerman]

I am still actively working on this one, but here you go. Maybe you can use it to start from.

[Jeremiah Nace]

Thanks for sending! These XML documents need to be customized using the EDI specs in the guide from the creator.  However, I was about 90% complete with building my XML, and you helped me see a critical issue. Much appreciated.

Attached is a copy of my finished draft that I'm testing.  It seems to work well for my EDI file, but the QC and time will tell.

I have another question, in the hopes you or someone else might know it. When we add the EDI source in SSIS, the output flow can only be one segment at a time. As such, I'm including the segid for the purposes of later joining/merging the data after the EDI Source processes each segment.  I find it hard to believe that the EDI source doesn't allow for fully de-normalized outputs to a wide singular table.  Am I missing something in the setup, or does everyone else parse each segment, include a segid, and then merge the data again later in the data flow?