SSIS

Bulk Insert Task Limitation:
The Bulk insert task does not log error causing rows. If you want your bad records to written to an error file or table, it is better to use Data Flow Task.

Bulk Insert Task will not fire triggers by default.