How to use Bulk Insert Task in SSIS

The Bulk Insert Task enables you to insert data from a text or flat file into a SQL Server database table in the same high-octane manner as using a BULK INSERT statement or the bcp.exe commandline tool.

In this example shows that how to load data from csv file

Source File:

Destination Table

CREATE TABLE PROSSIS_ZIPCODE (

ZipCode CHAR(5),

State CHAR(2),

ZipName VARCHAR(16)

)

Configuration

*** The Bulk Insert Task does not log error-causing rows. If you want bad records to be written to an error file or table, it’s better to use the Data Flow Task.

Cheers!

Uma