SSIS Load Data From Tab Delimiter File to SQL Server

This SSIS Integration Services article shows how to load data from a Tab delimiter text file (Tab Space) to the SQL Server table with an example.

The below screenshot shows the records in the Tab Space Employees text file.

Source text file

SSIS Load Data From Tab Delimiter File to SQL Server

Drag and drop the Data Flow Task into the control flow region.

Add Data Flow Task

Double-click to open the SSIS Data Flow Region. Then, drag the flat file source and double-click on it to open the Editor. Next, click the New button to open the Flat File Connection Manager Editor window.

SSIS Load Data From Tab Delimiter File to SQL Server 3

Click the Browse button to choose the Tab Delimiter text file.

Use Browse button to choose the text file

If the Tab delimited file’s first row has header names, checkmark the Column Names in the first data row option.

Checkmark the Column Names in the first data row

Change the Column Delimiter to Tab {t} within the Column tab. 

Change the Column Delimiter for SSIS Load Data From Tab Delimiter File to SQL Server

Use the advanced section to change the Data type. Here, the column data type must match the destination table; otherwise, it throws an error. After you finish, click OK to close the window.

Change the Column Data type

Next, drag the OLE DB Destination and double-click on it to open the Editor. Next, click the New button to configure the OLE DB Connection Manager. Here, we have chosen the existing one.

Use OLE DB Destination to configure OLEDB Connection Manager

Select the Load Data from Tab Space File table from the list. If not, click the new button to create a new one.

Select the SQL Table

Next, go to the Mappings tab to check the input and available destination column mapping.

Check the input and available destination column mapping

Run the SSIS Load Data From Tab Delimiter File to the SQL Server Table package.

Run the SSIS Load Data From Tab Delimiter File to the SQL Server Table package.

Open the SQL Management Studio to see the result.

View SQL Table Result