SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Import/SSIS ???
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

LonnieM
Starting Member

USA
15 Posts

Posted - 09/30/2009 :  17:13:49  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000