1 Reply Latest reply: Aug 28, 2013 6:00 AM by 936194 RSS

    DATA LOADING to TABLE

    936194

      Hi ,

       


      I have CSV File like following data
      920019,BROTHER TZE-231 12MM BLK ON WT EA
      892099,MULTI CLR LBL 1X2 5/8 1500PK BX
      GEMMTA250,TACKS,MAP,MED HEAD,.250ASST BX
      I need to load the data into SQL Table with SSIS package.
      Table column likes
      Item_NO | Item_Discp
      How can I ignore comma in "TACKS, MAP, MED HEAD,.250ASST BX"