Bulk Insert Task
When you get large amounts of data in the flat files, say from the mainframe systems or from third parties, and you want to import this data from the flat files into an SQL Server, you can use the Bulk Insert task. This task is the quickest way to copy large amounts of data into an SQL Server table or view.
Note the following when deciding whether to use this task:
The Bulk Insert task does not perform any transformations on the data while importing data from the source text file to the SQL Server database table or view.
When you embed this task in an SSIS package Control Flow, only the members of the sysadmin fixed server role can run the package.
You can use an XML or non-XML formatted file in the Bulk Insert task. A formatted ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
