Fixed length format file without delimeter [NC]

Cedric ROUVRAIS <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <OF52DFC723.E0750187-ON85257715.005431ED-85257715.0054AE26@us.world.socgen>
Hi guys,

Does anyone have a sample format file of fixed length fields without
delimeters. In the tests we are doing we keep getting

Msg 20079, Level 2
For bulk copy, all variable-length data must have either a length-prefix or
            a terminator specified

Failed to parse the format file correctly

Here is the format file we are playing with:

10.0
2
1 SYBCHAR 0 2 "" 1 id
2 SYBCHAR 0 6 "\n" 2 name

Basically this is a simple file with two fields. Field a is the first 2
            chars and field two is the next 6 chars.

For example (two lines):

11Fred
12Cedric


Thank you,

Cedric


*************************************************************************
This message and any attachments (the "message") are confidential, intended 
solely for the addressee(s), and may contain legally privileged information.  
Any unauthorised use or dissemination is prohibited.  E-mails are susceptible 
to alteration.  Neither SOCIETE GENERALE nor any of its subsidiaries or 
affiliates shall be liable for the message if altered, changed or falsified.
*************************************************************************
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.