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
