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.
*************************************************************************