Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Import/SSIS ???

Author  Topic 

LonnieM
Starting Member

15 Posts

Posted - 2009-09-30 : 17:13:49
Hello all,

I have to figure out a way to analyze the EDI (electronic data interchange) files concerning ASN (advance ship notices) from our vendors. I'm not really sure where to start. I can identify the lines I need by the first series of letters in each line. Here is a sample:

ISA~00~ ~00~ ~01~929222446 ~01~042653634G ~090923~1407~U~00401~000006502~0~P}
GS~SH~929222446~042653634~20090923~1407~6502~X~004010}
ST~856~65020001}
BSN~00~CS-0171895~20090923~14045500}
DTM~011~20090923}
HL~1~~S}
TD1~CNT~1~~~~G~100~LB}
TD5~~2~PKUP~L~PICK UP}
TD3~TL~~010458}
REF~VR~131456}
N1~SF~XXXXXXXX XXXXXX~92~131456}
N3~2000 SOUTH MAIN BLVD.}
N4~XXXXXXXX~XX~XXXX}
HL~2~1~I}
LIN~0001~BP~0601759~VP~77417}
SN1~~72~EA}
PRF~110051897}
PID~F~~~~AC20 BLU XXXXXXX .8M PLN-PLN 24}
CTT~2}

I have tried desparately to import this into some type of understandable structure with the Import Wizard to no avail. Sorry to pose such a general question but I'm just stuck.

Thank you,
Lonnie
   

- Advertisement -