Hello
I would like to know a more professional way to perform data import (TXT, CSV, XLSX and etc.) since today we do this via C # or by executing the SQL "Bulk Insert" command.
If I should use SSIS or some other more efficient way of importing this data and what its limitations are
Sincerely.
Depends on my price!. If you currently use bulk insert to load a particular table, I see no problem at all. SSIS or any other ETL tool such as DataStage is welcome when the need for data transformation (For example, if there is a need for Lookups, Data Type Change, Integration between Different systems of origin, among others.). In short, we can say: Use bulk insert to load a table for repositories and use SSIS for more elaborate data adaptation.
