.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

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

Posted By:Karthikeyan Anbarasan       Posted Date: March 22, 2011    Points: 200    Category: DataBase    URL: http://www.dotnetspark.com  

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 in SQL Server Integration Services (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 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

Basics of SSIS and Creating Package - SQL Server Integration Services (SSIS) - Part 1

Transforming SQL Data to Excel Sheet - SQL Server Integration Services (SSIS) - Part 2

Export Data using Wizard - SQL Server Integration Services (SSIS) - Part 3

Import Data using Wizard - SQL Server Integration Services (SSIS) - Part 4

Building and Executing a Package - SQL Server Integration Services (SSIS) - Part 5

Options to execute a package in SSIS - SQL Server Integration Services (SSIS) - Part 6 

Options to Deploy a package in SSIS - SQL Server Integration Services (SSIS) - Part 7

Scripting in SSIS Packages - SQL Server Integration Services (SSIS) - Part 8

Breakpoints in SSIS Packages - SQL Server Integration Services (SSIS) - Part 9

Check Points in SSIS Packages - SQL Server Integration Services (SSIS) - Part 10

Send Mail in SSIS Packages - SQL Server Integration Services (SSIS) - Part 11

For Loop task in SSIS Packages - SQL Server Integration Services (SSIS) - Part 12

Backup Database task in SSIS and Send Mail - SQL Server Integration Services (SSIS) - Part 13

Folder Structure in SSIS - SQL Server Integration Services (SSIS) - Part 14 

Conditional Split Task in SSIS - SQL Server Integration Services (SSIS) - Part 15

Sequential Container Task in SSIS - SQL Server Integration Services (SSIS) - Part 16

Create/Delete a table in SQL using SSIS - SQL Server Integration Services (SSIS) - Part 17

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



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.



Conclusion


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

 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend