SSIS: Configuring Bulk Insert Task
July 6th, 2011
No comments
Bulk insert task is used to copy large amount of data into SQL Server tables from text files. For example, imagine a data analyst in your organization provides a feed from a mainframe system to you in the form of a text file and you need to import this into a SQL server table. The easiest way to accomplish this is in SSIS package is through the bulk insert task.
Configuring Bulk Insert Task
Drag the bulk insert task from the toolbox into the control flow window.
Categories: Bulk Insert Task, Connection Managers, SQL Server, SSIS, SSIS 2008, SSIS Basics, SSIS Tasks Bulk Insert Task, Configure, Control Flow, SQL Server, SSIS