Import Flat file using Import an Export Wizard in SSIS(SCREEN SHOTS)

Import Flat file data into SQL Server using Import and Export Wizard in SSIS.

Right Click on SSIS Packages

Click on SSIS Import and Export Wizard

Click on next. Select Data source as flat file source. Click on browse and select the flat file path.

Select columns.

Select Advance. You can rename the columns, data type, output column width...

Select preview to preview the data

Choose destination as SQLserver native Client. Select database .default database is master.

Click on next

Click on next and Click Finish

Click on control flow .By default it will create table using Execute SQL task.if table already exist remove the CONTROL.

Click on dataflow.

Execute the package.

Verify in database whether data loaded successfully