Here's the query. It is a basic query called from a batch file, used in an SSIS package call.
::Handles the importing of the files from the device
::
"C:\Program Files\Log Parser 2.2\LogParser" "SELECT field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14,field15, field16, field17,field18, field19, field20, field21, field22, field23, field24, field25, field26, field27, field28, field29, field30, field31, field32, field33, field34, field35, field36, field37, field38, field39, field40, field41, field42, field43, field44, field45, field46, field47, field48, field49, field50, field51, field52, field53, field54, field55, field56, field57, field58, field59 INTO C:\sansaycdr\Formattedcdr111.txt FROM C:\cdr\cdr111.txt" -nFields:59 -iCheckPoint:"C:\cdr\Formattedcdr111.lpc" -i:TSV -o:TSV -iCheckPoint:"C:\cdr\Formattedcdr111.lpc" -oSeparator:";" -iSeparator:";" -headerRow:OFF -headers:OFF -filemode:1
Everything else works as expected. It just always skips the first record.
I'm working on another way to do this with log parser.
Can you use sub-queries with log parser?
What about variables?
If I could use a sub query or store the last record from the previous query in a variable, I could get this to work that way.
Thanks,
Jeff