Floating FB popout byF5debug

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

 

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.

Introduction

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 data source 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.

You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx

[more]

Steps

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

clip_image001

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

clip_image002

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

clip_image003

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.

clip_image004

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

clip_image005

Conclusion

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

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Comments (3) -

amit patil
amit patil
10/6/2012 9:47:25 PM #

While configuring bulk insert,you have specify columnDelimiter as tab,but it should be comma.as ur text file contain comma as delimiter so plz correct this

Praveen
Praveen
4/17/2013 2:44:06 AM #

@Amit Patil- Good that you recognised and saved my  time,as i got an error,didn't much focus on delimiter.Thanks!

Chander Sharma
Chander Sharma
6/13/2013 5:22:02 AM #

A simple article on Bulk Insert Task in SSIS - http://www.phpring.com/bulk-insert-task-in-ssis/

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter