February 17, 2010 at 3:43 am
Hi im trying to import a couple of text files from different sources but with the same error...the columns in the text file are delimited with | but the Flat File Connection Manager seems to want to ignore this and put them in one column...fine i thought i'll use a script component to take the column in and then output them as i wanted and then put them into the database...but i get an index outside the bounds of an array error after a certain amount of rows (just over 3,000)...the error was occuring after 1000 rows but by shortening the length of the input column i got more throughput...Im using the inputbuffer to get each row from the input column and then spliting it on the | via script.
Anyone had this problem before
thanks for any help:-D
Ang
February 17, 2010 at 3:52 am
Pipe-delimited files can generally be imported just fine with the flat-file source & if I were you I'd spend more time trying that method before wading into script. Presumably you found out where to change the field delimiter & had no success, for some reason. Can you describe what happened when you switched your field delimiter?
February 17, 2010 at 8:47 am
hi phil...thanks for replying..i went back to check my package with the idea of writing down what was going wrong and i noticed in my wallowing around changing everything i had left the text qualifier blank instead of typing in none. I changed that and hey presto the column deliminater stuck instead of defaulting. So all is well in my world again...
thanks again i do feel a bit silly all i needed was the cardboard cutout effect...
ang
February 17, 2010 at 8:51 am
🙂 happens to us all.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply