Below Script is the bat script for loading true CSV data... I need to change this to use for PIPE delimited data... anyone who has worked on LogParser before? Thanks a lot for your time.
@ECHO OFF
REM Input File = %1; Max Field Length = %2; Target Server = %3; Target Database = %4; Target Table = %5
@ECHO ON
LogParser -i:CSV -iCodepage:0 -headerRow:ON -fixedFields:ON -dtLines:10 -nFields:-1 -o:SQL -server:%3 -database:%4 -createTable:ON -clearTable:ON -maxStrFieldLen:%2 -ignoreMinWarns:OFF "SELECT * INTO %5 FROM %1" -e:0 -iw:ON -q:ON