hi !

i have this VERY weird DTS problem with csv. everything works fine until a
certain record was entered in the data. for example, the new member was C and
C have records c1,c2,c3,c4,c5 together with all the records of B (b1,b2,b3)
and A(a1,a2,a3).

c5 having the last row in the csv file, was not inserted in the temporary
table! but there are also some instance that this record is showing on the
table, but sometimes its not .


what do you think should i do in order for it to insert all of the data not
leaving the last row behind?

thank you very much!

Hello troubleD,

Is the row terminated correctly. I know a long time back we used to see this

BUG: Last Row of Fixed Length File Fails to Import When File Does Not End
with Row Delimiter
PSS ID Number: Q251119

i think it would be tiring if i will open anytime the csv file and insert
some delimeters on it. i have this made with a scheduled job every 30 mins
and i think its inappropriate to do it this way ?

would you recommend if i install service pack 4 of sql server? would it help ?

thank you for your reply.


"Allan Mitchell" wrote:

Hello troubleD,

On what Service Pack are you?

If the problem is with the file then no amount of service packing is going
to fix it. Open her up in a Hex Editor and look at the very last spaces.
Are they the same as your row terminator specified?


Allan