Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jimmyjazz1978
Starting Member
11 Posts |
 Posted - 2012-05-02 : 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 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-05-02 : 07:35:39
|
| Please do not cross post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=174201 |
 |
|
|
|
|
|
SSIS TEXT FILE IMPORT - MISSING ROWS