Data flow design (Sqlserver)

[jrprogr]

I am designing a data flow archieture.I need the suggestions.

What are the advantages of storing data of the flat files to sqlserver.

 

[SQLDenis]

>>What are the advantages of storing data of the flat files to sqlserver.

Are you serious? start here:

http://en.wikipedia.org/wiki/Flat_file_database

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[onpnt]

The only good thing about flat files is with the release of SQL Server 2005 it has been made even easier to store them in our databases

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[SQLDenis]

another good thing about flat files is that they are flat. You can store much more of them in a folder that way ;-)

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[ptheriault]

Is this for a school report?
I can't believe that anyone working for a company would even consider creating a system that uses flat files instead of RBDMS.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[jrprogr]

Thanks for the response.
I was told to design the data flow for the below sceniario..
We have Branch offices in different locations which will uses an application to create the raw data to flat file.Which BO(Branch office) in turn send the flat files (.csv) to our head office.

What is the best way to provide the data access to branches after cleansing the raw data from the flat files, and also BO will run the reports and also they have to send the flat files to the head office..

Could you please help me in the best possible ways to resolve it.

I have a solution creating the dts package at BO which will cleanse the data and dump into sqlserver..