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