Hi Team,
What are the major difference between Bulk Insert and data flow Task (like source and destination ) in SSIS and which one is more efficiency to load data.
Hi Team,
What are the major difference between Bulk Insert and data flow Task (like source and destination ) in SSIS and which one is more efficiency to load data.
The Bulk Insert task provides an efficient way to copy large amounts of data into a SQL Server table or view.
The Bulk Insert task can transfer data only from a text file into a SQL Server table or view. The destination must be a table or view in a SQL Server database.
The Data Flow task encapsulates the data flow engine that moves data between sources and destinations, and lets the user transform, clean, and modify data as it is moved. Addition of a Data Flow task to a package control flow makes it possible for the package to extract, transform, and load data.
This task has its own design surface like the Control Flow, where you can arrange task-like components called transforms to manipulate data as it flows in a pipeline from the source to a destination. The Data Flow is the heart of SSIS, because it encapsulates all the data transformation aspects of ETL. It can set several datasource and destination which is different with Bulk Insert task.
Drag and drop the data flow task and inside the data flow drag and drop flat file source and OLE DB destinations and copy the data. This approach is useful if we want to perform any SSIS transformations.
Use the SSIS Bulk Insert Task. This approach is more powerful compared to the previous one because internally, Bulk Insert Task uses Bulk Copy (BCP) operation (Which is very fast in SQL Server).
More details you may refer:
Regards,
Zoe
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October
Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)
5 people are following this question.
SSIS Scale Out and its services on local group policies
Where do I download SSDT July 2016 Update (ver. 14.0.60629.0) from?
we hope Microsoft can develop databases like mysql
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
SSIS - getting data from Oracle - not working preview and metadata refresh