Execute SQL and Bulk Insert Tasks in SSIS

The below
graphic shows the “BulkInsertData.txt” file which will be loaded into SQL
Server using the Bulk Insert Task.

4.   Right click the Connection Managers window and select New Flat
File Connections… from the popup window. This will open up Flat File Connection
Manager Editor window as shown in the snippet below. Enter the comma separated
flat file location and select the settings as shown in the snippet below.

5.   Click on the Preview Page to see how the data will look like once
it is loaded into the SQL Server Table using the Bulk Insert Task. Click OK apply
the changes made in Flat File Connection Manager Editor.

6.   Drag and drop “Bulk Insert Task” from the toolbox to the
Control Flow window and rename it “Load Data into Employee Table Using Bulk Insert
Task”.

7.   Double click the Bulk Insert Task to open up the editor window and
set the properties in Connection page as shown in the snippet below.

Continues…

Pages: 1 2 3




Array

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |