Posts

Showing posts from November, 2015

HOW TO CREATE FLAT FILES FROM SQL SERVER TABLE

Image
Today in Engineer's World, we are discussinga very important topic of SQL SERVER - Flat Files in very easy way. Posted By- +Manish Kumar Gautam+LIVE VIAR+ASP.NET SOLUTIONS
Click imaginationhunt.blogspot to see latest Blogs

Previous Post - STRING SEARCH USING REGEX METHOD IN C#

Flat Files in SQL SERVER

What are flat files and what did they give?Flat files are data files which give the table data. (Only Table Data Not Schema).
How to make flat files in SQL Server?Follow these simple steps:

1. Right click the database for which you want to create the flat file. Select Tasks -> Export Data...
2.SQL Server Import and Export Wizard window appear. Click on next button.
3.A window appears in which you have to choose the Data Source and its respective information.
By default- the Data Source is selected as SQL Server Native Client 10.0 or anything. Don’t change.Select the server name from the drop-down list or you can write the server name by yourself if the respective server name is not there.N…