Home Forums SQL Server 2008 SQL Server 2008 - General The last row in the sample data is incomplete. The column or row delimiter is missing or the text is qualified incorrectly. RE: The last row in the sample data is incomplete. The column or row delimiter is missing or the text is qualified incorrectly.

  • September 13, 2012 at 1:43 am

    #1537039

    Also, I tried using OLE DB Microsoft Jet 4.0 Provider connection to the CSV files folder with an OLE DB Source.

    One strange problem i see here is,

    The 2nd CSV file name is getting truncated in the data access mode table list, it is appearing as

    'Sample Unique Visitors Report for Samp Standards (SOV) Dev - Su' whereas the complete name is 'Sample Unique Visitors Report for Samp Standards (SOV) Dev - Sun. 1 Jul. 2012 - Fri. 31 Aug. 2012 (1).csv'.

    I tried passing this value using variable and failed.

    Is there any file name length limitation for CSV files while using OLE DB connection?