Monday 19 October 2015

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












Hope you like it


Posted by: MR. JOYDEEP DAS

No comments:

Post a Comment