Viewing 6 posts - 1 through 6 (of 6 total)
One way I can think of is to use a conversion utility program (eg: 2dos) to convert the file format from unix to dos before doing the extraction.
Or try...
July 2, 2004 at 8:40 am
#513179
update aTable set bField=-1 where aField='aValue' and bField is NULL
July 1, 2004 at 1:01 pm
#513029
One option is to set a default value to that particular column.
June 30, 2004 at 11:22 am
#512718
You can use xp_cmdshell and delete the file using dos command.
June 29, 2004 at 1:48 pm
#512532
Change the delimiter to something that will not occure in ur data (|, ~ etc). I dont think you can enclose a varchar field with double quotes and even if...
June 29, 2004 at 11:19 am
#512498
Can u show ur format file once?
June 25, 2004 at 2:41 pm
#512045