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

Biztalk out put Flat File has empty Records, how to avoid / remove

I am converting XML file to Flat file. I am struggling for two things. Want to achieve tag number without mapping file tag field from source to destination. Is there any way where I can populate it if in case any value in entire row. It shouldn't…
Shrilata Ellaboina
  • 103
  • 1
  • 3
  • 12
0
votes
1 answer

SSIS - How to prepare flat file source for fixed width format?

I have text file with structure like this: 123456789 , 1111111111 , 2222222222222 , xxxxxxx , zzzzzzz , 987654321 , 22222222222222 , 3333333333333333 , hhhhhhhhh , bbbbbbbbb , ... As you can see, delimiters are not at same place in second…
Olinad
  • 187
  • 1
  • 1
  • 13
0
votes
1 answer

Biztalk Flat File Schema Wizard: Parsing config files

I have several config files that may or may not have certain attributes. For example: Property1 : value1 Property2 : value2 . junk text junk text : line count between useful data varies in every file. junk text . Property3 : value3 //optional Is…
I Stand With Russia
  • 6,254
  • 8
  • 39
  • 67
0
votes
2 answers

mapping automatically columns into a destination flat file in SSIS

I need to export a table having more than 100 colonnes to a destination flat file, how can I map them automatically and not one by one one manually in SSIS SQL2012. There is any option as the automatic mapping existing in DTS?
paga sansil
  • 1
  • 1
0
votes
1 answer

SSIS Convert Blank or other values to Zeros

After applying the unpivot procedure, I have an Amount column that has blanks and other characters ( like "-"). I would like to convert those non-numberic values to zero. I use replace procedure but it only converts one at the time. Also, I tried…
user2812225
  • 1
0
votes
2 answers

Parsing flat-file database information into a multidimensional array

I want to make a class for parsing flat-file database information into one large analogous multidimensional array. I had the idea of formatting the database in a sort of python-esque format as follows: "tree #1": "key" "value" "sub-tree…
ADFDSADSA
  • 1
  • 1
0
votes
1 answer

Execute different SSIS packages based on Flat File name

I have several SSIS packages that parse different files into their respective tables. Using SSIS File Watcher task, I want to create a master package that will check a folder for the files and then select the proper sub package based on the…
RagePwn
  • 411
  • 2
  • 8
  • 22
0
votes
3 answers

Save array data in flat file

I have a column named ip_management.id_address in my database. I want to select all IP addresses and save them in a flat file (.txt). I tried to put them into an array first and then save it to text file. Here's my code: $query = "SELECT ip_address…
user2699175
  • 929
  • 2
  • 9
  • 16
0
votes
1 answer

Retrieving AD users from Powershell and exporting to csv, then Import csv to SQL via SSIS

Below is the Powershell CMD I use to export AD users to CSV. For some reason when i use SSIS to create a new flat file connection and use the exported CSV all the cell values contain "". When I open the CSV the cells dont show the Quotes. In the…
Murda Ralph
  • 175
  • 2
  • 4
  • 16
0
votes
2 answers

Unsigned Integer to signed Integer in SSIS

I have an SSIS Package which should take data from a Flat File (txt). One of the fields should be an Unsigned Integer and i should load it to an SQL table. In the "Flat File Connection Manager Editor" i set the "Format" of the flat file to Fixed…
OrenHenig
  • 80
  • 3
  • 9
0
votes
0 answers

SSIS - one data file from two data sources

Is it possible to write data from two data sources to a single flat file, with only one data flow? I have a process with three data flows - Run SP for its record count. Write dates and record count to flat file. Run SP again and write data to the…
unholymackerel
  • 89
  • 16
0
votes
1 answer

How to use the list feature in ffload to selectively load an ffdf?

How do I use the list feature in ffloadproperly to selectively load a part of an ffdf? I have read numerous times that it is possible to selectively load parts of an ff dataframe, but can't seem to get it working myself. My issue is that I'm trying…
bibzzzz
  • 193
  • 1
  • 10
0
votes
1 answer

Working code to import tab delimited txt file with more than 255 fields into two Access Tables

This code below will import a tab delimited file with over 255 fields into two tables. Just make sure when you design your two tables all your fields have the correct data types for the fields being imported. I originally created my tables by…
chris
  • 73
  • 3
  • 9
0
votes
0 answers

How to convert a hierarchical object to a flat object?

I have an object like this: var object = { a: 5, b: ["a", "b"], c: { a: 1, b: 2 } } And I would like to be transformed to a flat one like this: var output = { a: 5, b: "a, b", "c.a": 1, "c.b": 2 } Is there any function…
Totty.js
  • 15,563
  • 31
  • 103
  • 175
0
votes
1 answer

How to update a flat file using the same flat file in bash (Linux)?

I have a flat file separated by | that I want to update from information already inside of the flat file. I want to fill the third field using information from the first and second. From the first field I want to ignore the last two numbers when…
user2607210
  • 7
  • 1
  • 4
1 2 3
…
55 56