Based on the Transact-SQL BULK INSERT statement, the Bulk Insert task provides the fastest method of copying large amounts of data from a text file to Microsoft® SQL Server™. Because you cannot use any transformations on data imported with this task, you should use the Bulk Insert task only for copying operations, and in situations where performance is the most important consideration.
Add a Bulk Insert task to the DTS Designer workspace by dragging the Bulk Insert icon to the desired location.
After you have created a Bulk Insert task, you can select it on the DTS Designer workspace, and view or modify its properties on the context menu.