Bulk Insert task

The Bulk Insert task provides an efficient way to copy large amounts of data into a SQL Server table or view. For example, suppose your company stores its million-row product list on a mainframe system, but the company's e-commerce system uses SQL Server to populate Web pages. You must update the SQL Server product table nightly with the master product list from the mainframe. To update the table, you save the product list in a tab-delimited format and use the Bulk Insert task to copy the data directly into the SQL Server table. In bulk insert task cannot validate, clean or transform data with this task.

Source Connection: - click on new connection you will get File connection Manager Editor.

Select Usage Type:-       

Ø  Create File

Ø  Existing File

Ø  Create Folder

Ø  Existing Folder

In Format section you need define the Row and column delimiter

Ø  {CR}{LF}

Ø  {CR}

Ø  {LF}

Ø  Semicolon{;}

Ø  Comma{,}

Ø  Tab

Ø  Vertical Bar{|}

Destination Connection:-

Connection: - create a new connection.

Destination Table: - selected a table where you are going to store the data.

Executed successfully.