Electronic Data Interchange (EDI) is a file based on certain standards which opened in notepad only shows some numeric or alphanumeric code (encrypted) but when converted to readable format it shows the actual text. There are many different file formats. Has anyone dealt with EDI files importing data into SQL Server?
2. If you are trying to insert the data into relational tables, which you said you are, SQL Server provides no tools natively for working with EDI files, to the best of my knowledge. However, if you can find any application/converter that will convert the EDI files into XML or other non-proprietary formats, SQL Server would be able to ingest those.