Monday, 19 October 2015

SSIS Bulk Insert and How to Handel Error


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

No comments:

Post a Comment