Top "Flat-file" questions

How to import a fixed width flat file into database using SSIS?

Does any one have a tutorial on how to import a fixed width flat file into a database using an …

ssis flat-file

Flat file databases

What are the best practices around creating flat file database structures in PHP? A lot of more matured PHP flat …

php sql database flat-file

SSIS - Flat file always ANSI never UTF-8 encoded

Have a pretty straight forward SSIS package: OLE DB Source to get data via a view, (all string columns in …

utf-8 ssis flat-file

Is it faster to access data from files or a database server?

If I have a static database consisting of folders and files, would access and manipulation be faster than SQL server …

sql performance cgi flat-file

How to prevent SSIS from truncating the last field of the last data row in a flat file?

I have an SSIS package thats unzips and loads a text file. It has been working great from the debugger, …

sql-server ssis sql-server-2008-r2 flat-file

getting null values while loading the data from flat files into hive tables

I am getting the null values while loading the data from flat files into hive tables. my tables structure is …

hadoop null hive hdfs flat-file

SSIS mysterious error

I got only these 2 errors when converting flat files to database tables. The dataflow seems to work for other flat …

sql-server ssis flat-file

escaping tricky string to CSV format

I have to create a CSV file from webservice output and the CSV file uses quoted strings with comma separator. …

c# flat-file csv

Why doesn't SSIS recognize line feed {LF} row delimiter while importing UTF-8 flat file?

I am trying to import data from a utf-8 encoded flat file into SQL Server 2008 using SSIS. This is what …

sql-server sql-server-2008 utf-8 ssis flat-file

Is there an smart way to write a fixed length flat file?

Is there any framework/library to help writing fixed length flat files in java? I want to write a collection …

java flat-file fixed-length-record fixed-length-file