I've got a text file that is being a complete pain in the arse about importing. It's delimited, but doesn't seem to have a row delimiter, which is what's throwing everything off. I can specify no delimiter in a dts import, but it doesn't let me actually move the delimiter to the end of the file. I can only move it to position 369, when in reality the file has 527. It doesn't seem to recognize the remainder of the file at all, and treats it as if it doesn't exist. I've also tried using bcp using the following command:
bcp dbname.dbo.tablename in \\network\projects\client\source\file1.txt -Uusername -Puserpass -Sservername
The first row will import properly, but then every following row is screwed up. I would expect this has something to do with not having a row delimiter.
Any suggestions/help would be appreciated.
bcp dbname.dbo.tablename in \\network\projects\client\source\file1.txt -Uusername -Puserpass -Sservername
The first row will import properly, but then every following row is screwed up. I would expect this has something to do with not having a row delimiter.
Any suggestions/help would be appreciated.