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
1 answer

Access properties of Flat File Destination in SSIS via Script

I have a Data Flow task that has a Flat File Destination in it. The 'Overwrite' property is set to False by default. I have a project parameter (boolean) that I need to check and if it is true then I need to set the Flat File Destination Overwrite…
Leslie
  • 3,604
  • 7
  • 38
  • 53
0
votes
1 answer

Use XSLT to create DAT file

I have an xslt file which creates a simple flat file. The output file originally had a .txt extension, but now it needs to be a .dat extension. Everything was perfect, but once I changed the extension, the .dat file does not interpret the new line…
RXC
  • 1,233
  • 5
  • 36
  • 67
0
votes
4 answers

Replacements for FoxPro

I am looking for a replacement our Foxpro application. Microsoft Visual FoxPro is a Boeing non standard software application. Microsoft has not released a new version since 2007 and has announced it will no longer be supporting the software. The…
user3334061
  • 1
  • 2
0
votes
0 answers

Reading XML file to database with SSIS

I need to read large XML file to database (SQL Server 2008 R2). The whole XML file needs to be inserted into single database, single table and single column. After that it will be processed further. 1) I have a flat file connection manager to…
Juha S
  • 25
  • 1
  • 7
0
votes
2 answers

Better way to export data from one database to another (SQLSever)

I'm importing a big flat file (about 400.000 rows and 255+ columns) into SQL Server Management Studio through the import wizard. To get the right variables I use Suggest types, but I have found that I need to search through all the rows to get the…
Mace
  • 1,259
  • 4
  • 16
  • 35
0
votes
3 answers

Biztalk Editor v3 output specification without eol

I have a problem with output spec, is possible to create the spec without any EOL character - flat file in one line? I use BizTalk Editor v3.00... i think is a 2001.
Nerus
  • 167
  • 1
  • 2
  • 13
0
votes
2 answers

NULL Appearing in FLAT File, unable to Parse using XSD

We are trying to covert position based FLAT file (https://i.stack.imgur.com/EryDU.jpg) to valid XML. The file contain Header, Detail Line, Trailer. Detail Line has data character, whilespace Character and ALSO some other special character like…
user1589385
  • 3
  • 3
0
votes
1 answer

trouble with php flatfile

So im trying to write to a flatfile. A word from a database is written every time it meets a certain criteria. The problem is after the script runs, only the last word that met the criteria shows up in the file. Obviously the words are being…
Nick lK
  • 2,647
  • 4
  • 16
  • 14
0
votes
1 answer

CKeditor displaying HTML tags in browser

I have been searching for a possible cause of this issue but I couldn't find it. I already saw this topic here but it didn't help me. I am building a very simple CMS using exactly this technology, plus CKeditor. Everything works just fine until I…
viriato
  • 859
  • 2
  • 13
  • 26
0
votes
2 answers

When to use a flat file over RDMS/NOSQL/etc

The domain of problems I work on are web applications and web APIs. The longer I've been a developer, the more I've begun to question the need for a relational database even though the predominant thinking seems to be to stuff everything into a…
nickb
  • 9,140
  • 11
  • 39
  • 48
0
votes
2 answers

SQL Server 2005: Improving performance for thousands or Insert requests. logout-login time= 120ms

Can somebody shed some lights on how SQL Server 2005 deals with may request issued by a client using ADO.NET 2.0. Below is the shortend output of SQL Trace. I can see that connection pooling is working (I believe there is only one connection being…
Rad
  • 1
  • 1
0
votes
2 answers

insert the space into Filereader

I have to write the code to insert the space in middle of falt file. I have text as below, each line column length should be same 123 123256 123323 the above string should looks like 123--- 234256 987323 After 123 we need space. could you…
Software Enginner
  • 675
  • 2
  • 14
  • 43
0
votes
0 answers

SSIS Expression - get the next characters

I need to get the exact file name of a txt file as the connection string of my flat file connection manager. I have used the following expression: @[User::DataLoadDir]+"Myfile_" + (DT_STR, 4, 1252) YEAR (getdate()) + RIGHT ("0" + LTRIM ((DT_STR, 4,…
Liz
  • 323
  • 7
  • 17
0
votes
4 answers

SSIS parsing of an irregular flat file?

I'm pretty familiar with SSIS parsing of regular delimited text data files, however, I'm looking for some advice on an approach to tackle a file that looks like this test file: ISA*00* *00* *01*220220220 *ZZ*RL CODE…
ElHaix
  • 12,846
  • 27
  • 115
  • 203
0
votes
0 answers

Dynamically set SSIS connection manager for flat files

I have a number of flat files which have one of two formats (soon to be four) and the columns differ slightly. I have set up 2 different connection managers for the different formats, but I would like to choose the appropriate connection manager for…
CatchingMonkey
  • 1,391
  • 2
  • 14
  • 36
1 2 3
…
55 56