HomeForum
Welcome, Guest

Flat files with multiple lines per record
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Flat files with multiple lines per record

Flat files with multiple lines per record 1 year, 1 month ago #2584

  • Chris
  • OFFLINE
  • Fresh Boarder
  • Posts: 13
  • Karma: 0
Hi,
Do any of the versions of Visual Importer handle flat files with multiple lines per record?
We have to import several files into an SQL Server and they each have 3 to 9 lines per record in each file.
Each file is 101 bytes wide, however, each line has a different structure, so each record is really 303 to 909 bytes, and is wrapped within the file with the first character in each line indicating that it is the first, second, third, etc. line of a given record.
Also, in most cases, the last few bytes of any line is the first part of a field continued in the next line, after the record line number.
Thanks,
Chris

Re: Flat files with multiple lines per record 1 year, 1 month ago #2585

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
Very interesting task you have got over there.

Try Advanced ETL Processor there are some new examples in the latest version.
They should help

or publish your data here we will be happy to help

John
  • Page:
  • 1
Time to create page: 0.15 seconds

Testimonials

"Advanced ETL Processor it is the only software which treats our POP3 server as a database server."

Tom Barker,
Director of Information Technology

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top