Kelly,

Many years ago, I worked with EDI data feeds into SQL Server. Back then, I extracted EDI information and converted into text files for import into SQL Server. I'm guessing that the same would hold true today. So, use your EDI translator to create the text files from the EDI transmissions and use SQL Server to import the text created from the translator as you would any other text data.

HTH

>My boss wants me to create an import routine that will accept EDI data. I have never worked with EDI before and have no idea where to start. How do I get started, what do I have to becareful of, and how does the SSIS package dffer for an EDI import versus say a text file import?
>
>Thanks in advance
>Kelly