Step 1: Following below is the sample flat file which need to be uploaded in SQL Server.
 |
| Flat File |
Step 2: Open SQL Server 2008 and go to Database -->System Databases --> tempdb and then right click on the tempdb and go to Tasks --> Import Data
Step 3: On clicking Import Data as shown in previous step, SQL Server Import Export Wizard pops up. Click Next.
 |
| SQL Import Export Wizard |
Step4 : On Clicking NEXT another window pops up. Do the following below and as shown in pic:
Select the Data Source as "Flat File Source"
Browse the Flat file.
Set Header Row delimeter as "Tab"(depends how your flat file is delimited)
Tick the check box if first row of flat file contains column names.
