Stack Overflow
Stack Overflow

Questions tagged [flat-file]

A flat-file database model is any system using a single file for storage with one record per line, usually plain-text or text mixed with binary data.

A "flat file" is a plain text or mixed text and binary file which usually contains one record per line or 'physical' record (example on disc or tape). Within such a record, the single fields can be separated by delimiters, e.g. commas, or have a fixed length. In the latter case, padding may be needed to achieve this length. Extra formatting may be needed to avoid delimiter collision. There are no structural relationships between the records.

Typical examples of flat files are /etc/passwd and /etc/group on Unix-like operating systems. Another example of a flat file is a name-and-address list with the fields Name, Address, and Phone Number.

Source: Wikipedia (Flat file database)

830 questions
0
votes
0 answers

SSIS - Flat file conection with same column/row delimiter

I have a *.txt file. And the data format is like below : Guest|Orient| |HMI1|0|-480| Guest2|Orient2| |HMI1|0|-480| It will not format correctly when I preview the data. Already try all row delimiter-CRLF,CR,LF,;,:,tab,|. Need advice. Thanks
user2286756
  • 211
  • 1
  • 2
  • 11
0
votes
1 answer

Optional lines in Flatfile in biztalk

I have to flatfiles that i need to convert into UBL using Biztalk. Everything is fine until I reach the end of the flatfiles. One of them looks like this RZ0100120400R;RZ01-00120400;RAZER MAMBA 2012…
Oedum
  • 796
  • 2
  • 9
  • 28
0
votes
1 answer

SSIS Flat File data column compare against table's column data range

I need to develop a SSIS Package where I will need to import/use a flat file(has only 1 column) to compare each row against existing table's 2 columns(start and end column). Flat File data -…
Aric Smith
  • 3
  • 5
0
votes
1 answer

SSIS - Flat file connection manager corrupted

I had a flat file connection manager with over 800 columns defined in Fixed Width format that was working fine until yesterday. When I now open a flat file with this connection manager I see those black squares which I think are introducing spaces…
user2240715
  • 113
  • 1
  • 2
  • 7
0
votes
2 answers

PHP - Sort array by date - not first element

Reading from a flatfile... I need to display array elements sorted by DESCENDING date (= most current date displays first). Not sure... Is there a way to simply sort the data by element[1] or do I need to put this data into a second array and then…
mar2195
  • 103
  • 1
  • 10
0
votes
2 answers

PHP - Create UL Nested Lists From Flatfile

(Before anyone asks... I cannot use a MySQL database for this project.) Using PHP, I need to create nested UL's from a flatfile database. The issue that I'm having is that I don't want duplicate items displayed. I could explain further, but if…
mar2195
  • 103
  • 1
  • 10
0
votes
2 answers

SQL Server table or flat text file for infrequently changed data

I'm building a .net web app that will involve validating an email input field against a list of acceptable email addresses. There could be up to 10,000 acceptable values and they will not change very often. When they do, the entire list would be…
user2391532
  • 13
  • 4
0
votes
1 answer

SSIS Flat file import - rolling data

I need to import a flat file into a database table every hour, however the file itself is continuously updated by an application (file doesn't lock so that's no problem). What i need is to make sure that i'm only importing the latest data for the…
GPH
  • 1,817
  • 3
  • 29
  • 50
0
votes
1 answer

XSLT iterate over flat file

Can you iterate over a flat file with XSL? I'd like to ls>myfile for each line of myfile apply-template
weberjn
  • 1,840
  • 20
  • 24
0
votes
1 answer

How to create a flatfile from a series of tables in Access?

I have a series of tables in an Access 2007 database. I am trying to find a way of outputting a flat-file to an excel spreadsheet that combines all of the tables so that each row of the flatfile represents a unique combination of the table rows from…
AdamDynamic
  • 761
  • 6
  • 15
  • 29
0
votes
0 answers

ffdfappend crashing R

I'm a bit of an R newbie but I'm trying to use the acast,ff,ffbase packages to create a pretty large R object (5 mil rows x ~17k cols) - after a SQLServer dataset has been brought in and been melted in casted into smaller dataframe chunks (can't, of…
user2183510
  • 1
0
votes
1 answer

Relational flat-file database

For a small application, need to use a flat file database with relational capabilities (2 or 3 tables). Couple questions regarding this schema: Does such databases exist? Any performance hits with large datasets? (say, 10k-20k entries) The reason…
sqram
  • 7,069
  • 8
  • 48
  • 66
0
votes
1 answer

Writing large volume of web post requests to flat files (File based Queuing )

I am developing a Spring Based Web Application which will handle large volume of requests per minute and this web app needs to respond very quickly. For this purpose, We decided to implement a flat-file based queuing mechanism, which would just…
Alex
  • 1
0
votes
2 answers

Running a script component before writing data to a flat file in SSIS

In my SSIS package I need to modify the flat file name that will get creted at the last step of my data flow execution. Currently, I need to transit input data though the Script Component + do a code modifications to a variable that will form a flat…
Maxim V. Pavlov
  • 10,303
  • 17
  • 74
  • 174
0
votes
1 answer

locating a flat file from SQL server 2005

I have built an SSIS job in visual studio 2005 that accesses a flat file and updates a table in SQL Server 2005. This works perfectly. I then store a copy on SQL Server by using the server storage option in the protection level property. When I try…
Ronnie Carlin
  • 1
1 2 3
…
55 56