SQL Server Integration Services (SSIS) – Part 18 – Bulk Insert task in SSIS

Posted by in Sql Server category on for Intermediate level | Points: 250 | Views : 22274 red flag
Rating: 5 out of 5  
 1 vote(s)

This is part 18 and the article of the series of article on SSIS. In this article, we are going to learn how to bulk insert in SSIS.


In this article we are going to see on how to use Bulk Insert task in SSIS, This task as name specifies uses the BULK insert of the values to the destination. Destination can be any of the datasource as we have like OLEDB, excel, etc. Let’s jump into this and see on how to use this task and how to configure the same using SSIS packaging.

To follow my series of articles on SSIS packages refer to the below URL’s


Follow steps 1 to 3 on my first article to open the BIDS project and select the right project to work on integration services project. Once the project is created, we will see on how to use Execute SQL task and create a table using the same.
Drag and drop a Bulk Insert task from the tool box to the designer window as shown below

The input file which has the bulk data to upload to the SQL Server will look like below.

Now double click on the Bulk Insert task to make the configuration. It will open the window as shown in the below screen.

Here in the source we have selected the file and in the destination we have selected the table.
In the table at present we have the list of records as shown in the below screen we will see after executing the package how many records are available.

Now we will execute the project and you will see the output.


So in this article we have seen on how to use Bulk Insert task in SSIS.

Page copy protected against web site content infringement by Copyscape

About the Author

Full Name: Karthikeyan Anbarasan
Member Level: Silver
Member Status: Member,Moderator,Microsoft_MVP,MVP
Member Since: 1/2/2011 3:00:14 AM
Country: India
Thanks Karthik www.f5Debug.net
www.f5Debug.net Around 5 years of experience in Microsoft technologies like ASP.Net, VB.Net, C#.net, SQL server, Biztalk Server, WCF, WPF, SSIS, SSRS, SSAS, AJAX and working as Senior Analyst in a US based MNC.

Login to vote for this post.

Comments or Responses

Posted by: Tripati_tutu on: 3/12/2011 | Points: 25
Nice to see these series of articles.
Posted by: Karthikanbarasan on: 3/12/2011 | Points: 25
Thanks tripathi!!!!

Login to post response

Comment using Facebook(Author doesn't get notification)