Good Morning, Both BizTalk and Data Junction have pre-built HIPAA 834 transforms. Is anyone aware of a canned HIPAA 834 transform for SSIS? Just wanted to check before I built one from scratch. Would anyone else be interested in this if I were to develop it? Thanks, Don Trainer

There is no such component that I have ever seen. I can't speak to general market demand, but I'd expect that someone would be interested in a high-performance HIPAA solution that didn't require purchasing BizTalk licenses. With that said, you definitely have your work cut out for you if you take this on - the HIPAA file specs are nothing if not complex, and in my personal opinion they lend themselves better to the message-based metaphor of BizTalk than they do to the bulk/set-based metaphor of SSIS...

We already have built a couple of VB6 applications that coerce the data and create the files. Unfortunately, there isn't much integrity checking internally and when we have a problem it takes some real digging to find. I agree that message based BIZTalk might be a better solution but for our needs its like killing a mosquito with a thermonuclear device. I am familiar with the file specs so I think I am going to invest in building one. Who knows, I might actually be able to make a nickle or two from it . Don

I would defnitely be interested in such a transform. Ive considered it myself but the 834 is an ugly spec. Please post when you have some progress.

Hasanyone ever make one? I'd LOVE to see/use it! Please let us know.

We are looking at doing this too. I setup a server with WinSvr 2003 and the latest BizTalk but the HIPAA piece is not an easy thing to do... we followed all the steps to get the HIPAA accelerator to work and it doesn't. Have you had any progress doing it in SSIS? Do you have any good reference links that you could help us out with? Thanks!!! Max

Unfortunately our corporate IT department has shot down every attempt we have made to bring SSIS to the table. They claim to have a solution using their home grown system yet no one can produce a single example of where it has been successfully implemented withoutextensive human intervention and the use of external access databases. Wish I had better news. Don

Thanks for the update Don! I have been busy searching and I think I found a solution that will make you very happy... HIPAATalk - Contains stored procedures and sample DTS packages for parsing and converting X12 to flat tables and creating HIPAA-compliant X12 files. Currently reads 820, 834, 835, 837P, 841, 997, TA1, and creates 835, 837-I, 837-P, 997, TA1. Other trans I'm going through the help files now, but look at this note from the author... A note from the author: Istarted writing the HIPAATalk database in the fall of 2005 after an inspiring conversation with an associate of mine named Marcia. She had this insane idea to use DTSto parse an 834 file as though it were a simple delimited file into a table with generically named columns. From there, she was using some basic select statements to get to the data elements she needed for her legacy system. Ithought it was crazy, since Ihad gone the "official" route of spending thousands of dollars on Microsoft's BizTalk Server and the HIPAA Accelerator. Not only had Ispent a bunch of money, Iwas still spending countless hours developing maps and file specifications and getting frustrated at the fact that I had to sift through the event viewer to find out why a file failed during translation. Ifigured Iwould give Marcia's method a shot, since Ihad a bit of experience with DTS and SQLServer 2000. My first attempt at parsing the 834 into a table in my SQLServer database took about 30 minutes, after that, converting it to a flattened table took another couple of hours of T-SQLdevelopment. By the end of the day, Ihad a DTS package and a stored procedure which could take an 834 file, bulk-load it into a temporary table, and from there convert it to a flattened table of usable enrollment data, ready for import into my legacy system. And it only took 30 seconds to run on the same file that took BizTalk 45 minutes to convert to the same format. Sweet. You can find HIPAATalk at SourceForge... http://sourceforge.net/projects/hipaatalk/ -Max

Good Morning, Both BizTalk and Data Junction have pre-built HIPAA 834 transforms. Is anyone aware of a canned HIPAA 834 transform for SSIS? Just wanted to check before I built one from scratch. Would anyone else be interested in this if I were to develop it? Thanks, Don Trainer Check CozyRoc's EDI Source component. It has already been used successfully to process 210, 810, 820, 834, 852 formats.SSIS Tasks Components Scripts | http://www.cozyroc.com/

Okay...two years later. We are interested if you have this built. Joe

I went looking for a HIPAA data translator at one point. My company is small, so the BizTalk route was WAY too expensive. I did find this open source project which I have implemented and find very useful. You still have to build map files for the various files (I have written ones for 835, 834 and 837I), but it works consistently and can be scripted easily. Its called chiapasCore. http://sourceforge.net/projects/chiapas/ FYI, while it is an open source project, the program was written in .net. Scott Dolan

Hi Scott, I'm glad you found Chiapas useful. I'm the author, and I just founded a business to support Chiapas and develop it further (Chiapas EDI Technologies, Inc.). If you need any help, please feel free to drop me an EMail - richard.temps@gmail.com. If you have any feedback, I'd enjoy hearing about it. Best, Richard Temps