This is a bit on the weird side..
I've got a DTS package which imports a text file and builds a table with it all standard stuff, but for some reason it skips the final record, and I have no idea why..
If I duplicate the final row, or add another crlf (blank record in effect) the row in question will import, so I know there is nothing wrong with the data in the row.
I can get around it by adding in a blank record at the end of the data, but I'd like to keep the data as clean as possible.
Has anyone come across anything like this before?


LinkBack URL
About LinkBacks
Reply With Quote
No errors reported..