The SSIS Bulk Insert task used to copy data from large Flat File to Microsoft SQL Server Table. This is generally used to handle the Large Flat file copy to Table.
We have to remember:
1. The flat file should be PURE. That means we have to check the flat file very well before use.
2. It can copy one flat file data to a single table only
What we needed:
1. Flat file connection manager for retrieving data from flat file
2. OLEDB Connection manager to save the data in destination
3. Bulk Insert Task in SSIS control flow tab
Hope you like it
Posted by: MR. JOYDEEP DAS