flat-file Questions
5
Solved
8
Solved
Does anyone know of any tools to provide simple, fast queries of flat files using a SQL-like declarative query language? I'd rather not pay the overhead of loading the file into a DB since the inpu...
9
Solved
A friend and I were debating about whether he should use MySQL or a flatfile database for his website's backend. I told him to go with MySQL because it was structured, held records well, and was co...
2
Solved
I have a txt file that contains contact info for businesses. Currently, each line contains a different piece of data for the business. I'm attempting to construct a pipe-delimited file with all the...
4
Solved
I'm making a chat program, and I need a place to store messages. The client would contact the server every x seconds with the last received message id, and the server would find all messages with a...
3
Solved
When I attempt to import a .csv comma-delimited flat file into a Microsoft SQL server 2008R2 64-bit instance, for string columns a NULL in the original data becomes a literal string "NULL" and in a...
Pentlandite asked 27/6, 2013 at 18:55
2
Solved
I am trying to import the contents of a log file into a database using Spring Batch.
I am currently using a FlatFileItemReader, but there are unfortunately many log entries that doesn't catch. The...
Rockabilly asked 30/3, 2012 at 8:56
8
Solved
I would like to see some examples of simple flat file databases and how they are accessed through a data layer. I've written to and read from a flat file before, but I have not ever created a data ...
Levitt asked 8/1, 2010 at 23:32
6
Solved
Does anybody know of any good libraries to convert a flat file to Java objects? I found flatworm but I am looking for alternatives.
1
Solved
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 bein...
3
Solved
I have a large data structure, a tree, that takes up about 2gb in ram. It includes clojure sets in the leaves, and refs as the branches. The tree is built by reading and parsing a large flat file a...
Councilor asked 9/5, 2013 at 18:13
11
Solved
What are the best practices around creating flat file database structures in PHP?
A lot of more matured PHP flat file frameworks out there which I attempt to implement SQL-like query syntax ...
1
I am trying to read a text file in SSIS (2005/2008). I created a connection to the file and placed flat file source, and it works fine in preview but when I try to run I get error saying:
[Derive...
8
Solved
I want to save the objects I generated in a program. After restart the App should load automaticly all Objects in an Array. I want to write them in a file and parse them after restart. Are the othe...
3
Solved
Does any one have a tutorial on how to import a fixed width flat file into a database using an SSIS package?
I have a flat file containing columns with varying lengths.
Column name Width
--------...
2
Solved
I am making a little add-on for a game, and it needs to store information on a player:
username
ip-address
location in game
a list of alternate user names that have came from that ip or alternate...
3
am experiencing a very strange issue in SSIS (2008).
Basic workflow is as follows..
Using a flatfile source (CSV), bring into SSIS, push into SQL.
When process is run on dev environment, everyth...
Unpeg asked 27/5, 2011 at 5:11
7
Solved
Presented alongside a polling facility on a webpage is the following input fields that enables the visitor (voter) to enter their details in a raffle for a hamper as a reward for their effort in ta...
Outrage asked 11/11, 2011 at 20:12
3
Solved
I have written a VBA app that opens a folder in outlook and then iterates through the messages. I need to write the message bodies (with some tweaking) to a single flat file. My code is as follows....
1
Solved
Is there a way to access FlatFiles with the Microsoft.Jet.OLEDB.4.0 driver in SSIS ?
The acces via the FlatFile Source is much better, it´s just about if there exists a way to do it with the Jet d...
4
Solved
I have this method signature: List<ITMData> Parse(string[] lines)
ITMData has 35 properties.
How would you effectively test such a parser?
Questions:
Should I load the whole file (May I ...
Selfeffacing asked 16/8, 2011 at 13:6
4
Solved
I have a file that looks something like this:
|29923C|SomeGuy,NameHere1 |00039252|042311|Some Address Info Here |
|47422K|SomeGuy,NameHere2 |00039252|042311|Some Address Info Here |
|98753D|SomeGu...
3
Solved
I'm collecting some system data in a flatfile, which has this format:
YYYY-MM-DD-HH24:MI:SS DD1 DD2 DD3 DD4
Where DD1-DD4 are four items of data.
An example of the file is this:
2011-02-01-1...
1
Solved
I am in the process of developing an SSIS job on my workstation which a Data Flow Task open a comma delimited flat file on my local workstation and imports the data to a SQL server database on a re...
Curium asked 8/2, 2011 at 22:41
4
Solved
I have some log files I would like to sift through. The content is exactly what you expect in a log file: many single lines of comma separated text. The files are about 4 gigs each. File.each_line ...
© 2022 - 2024 — McMap. All rights reserved.