3 Replies Latest reply: May 14, 2014 9:53 AM by Francisco Cordoeiro RSS

    Loading a Large Text File

      Hi,

       

      I'm having a problem loading a text file with 1.4 milions lines...

       

      LOAD ExternalQABatchKey,

           SalesTransactionLineKey,

           PharmacyID,

           DayKey,

           SalesDateTime,

           HMRFixedProductPackCode,

           ProductID,

           ProductName,

           UnitPrice,

           QuantitySold,

           PricePaid

      FROM

      SalesTransactionLine_OutliersData.txt

      (txt, codepage is 1252, embedded labels, delimiter is '|', msq);

       

      It only loads next to 700.000 lines and no error is registered!

       

      Thanks in advance,

       

      Francisco