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 |
|
corkyhawk
5 Posts |
 Posted - 2010-02-26 : 16:47:10
|
| I'm trying to import a flat file in SSIS that uses double pipes (||) as the delimiter between columns. If the file is relatively small it works fine. However with larger files I start getting errors where it basically ignores the delimeter for one of the fields and loads the rest of the current row plus part of the next into one column, but then loads the rest of the current row correctly. I've talked to Microsoft and they think it might have to do with the buffer getting filled after the first pipe so that when it reads the second pipe it doesn't recognize it as a delimiter. That doesn't seem right to me, but I don't have a better explanation. We've done some testing and the file loads fine if the delimiter is changed to a one character delimiter. I know I can load the file other ways, but would really like to use SSIS to parse the file if possible. Has anyone else run into this problem or does anyone have any suggestions? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-26 : 23:53:43
|
| can you try adjusting the buffer size and see if it works?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Importing flat file with 2 character delimiter