Sue_H,

I did created a format file, when I use that the file gets exported but it's empty, when I don't that's when I get a message that the file is too big or corrupted.

10.0

11

1 SQLCHAR 0 12 "," 1 FileID ""

2 SQLCHAR 0 255 "," 2 FilePath SQL_Latin1_General_CP1_CI_AS

3 SQLCHAR 0 12 "," 3 FileTypeID ""

4 SQLCHAR 0 255 "," 4 FileName SQL_Latin1_General_CP1_CI_AS

5 SQLCHAR 0 24 "," 5 DateUploaded ""

6 SQLCHAR 0 12 "," 6 PageNbr ""

7 SQLCHAR 0 0 "," 7 FileData ""

8 SQLCHAR 0 12 "," 8 UserID ""

9 SQLCHAR 0 37 "," 9 FileNetID ""

10 SQLCHAR 0 24 "," 10 DateEffective ""

11 SQLCHAR 0 3 "\r" 11 DrillingReportRollup ""

Eirikur,

I'm not using either -c or -w character type. I can do some testing and see what I get.

Thanks.