SSIS Bulk Insert and How to Handel Error

Introduction

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

Here is the Video demo for it…

https://youtu.be/nMRSzl_gvnI

Hope you like it

Posted by: MR. JOYDEEP DAS