|
jimmyjazz1978
Starting Member
United Kingdom
10 Posts |
 Posted - 05/02/2012 : 06:51:08
|
0I am importing a text file encoded in UTF8 - without BOM usign a flat file source to OLE DATABASE task .
Format of Flat file connection is DELIMITED, 65001(UTF-8), Text Qualifier ( none ) , Header Row delimiter is {CR}{LF} , Header Rows skip is 2 , and the column names in the first data row . Row Delimiter is {CR}{LF} and column Delimiter is Vertical Bar {|}.
Format of data is like so ;
SPECIAL products in q: Reported on 01/11/2011 {CR}{LF}
{CR}{LF}
Serve|Co|Q Number|Doc Name|{CR}{LF}
HE| AUS|000021|Dert|{CR}{LF}
The problem is that SSIS is not seeing the first 112 rows ? I cant work this out . It is driving me crazy so pl help ?
All the other rows in the fiel starting from 113 import into the database with no problems. No errors when SSIS package runs.
Edited by SSIS User2011 39 minutes ago
Bizzare |
|
SSIS TEXT FILE IMPORT - MISSING ROWS
Topic Locked
