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:49:55
|
| I 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.Bizzareedit: moved to proper forum |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-05-02 : 12:24:24
|
| in your sample data the first row has to column delimiter. is that the case for the first 112 rows?<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-02 : 19:46:28
|
| i think if delimiters are inconsistent you may be better off doing this using BULK INSERT by specifying delimiters using a format file------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SSIS TEXT FILE IMPORT - MISSING ROWS