Rowterminators
Okay, revising this question, as I've messed around with it some.
Rowterminator is not working to, erm, terminate the row. Since I'm BCPing this file out, I messed with it a bit, and I added a pipe to the end of each row, as per:
20 *DMG*D8*19821116*M|
21 *DMG*D8*19841231*M|
22 *DMG*D8*19900927*F|
23 *DMG*D8*19880609*M|
24 *DMG*D8*19750414*M|
25 *DMG*D8*19750218*F|
26 *DMG*D8*19550412*F|
27 *DMG*D8*19601222*M|
...then I changed the bulk insert command to:
bulk insert edi.dbo.dmg from '\\tesla\sql data\load\dmg.txt' with (fieldterminator = '*', rowterminator = '|')
I mean, you can't really get more explicit than that, can you? And yet still, I get a truncation error on column 6, where the system shouldn't even be going, because there's a rowterminator symbol after column 5.
Any ideas? Thanks.
Rowterminator is not working to, erm, terminate the row. Since I'm BCPing this file out, I messed with it a bit, and I added a pipe to the end of each row, as per:
20 *DMG*D8*19821116*M|
21 *DMG*D8*19841231*M|
22 *DMG*D8*19900927*F|
23 *DMG*D8*19880609*M|
24 *DMG*D8*19750414*M|
25 *DMG*D8*19750218*F|
26 *DMG*D8*19550412*F|
27 *DMG*D8*19601222*M|
...then I changed the bulk insert command to:
bulk insert edi.dbo.dmg from '\\tesla\sql data\load\dmg.txt' with (fieldterminator = '*', rowterminator = '|')
I mean, you can't really get more explicit than that, can you? And yet still, I get a truncation error on column 6, where the system shouldn't even be going, because there's a rowterminator symbol after column 5.
Any ideas? Thanks.
