1
Hello
I would like to know a more professional way to import data (TXT, CSV, XLSX and etc) given that today we do this via c# or by running the SQL "Bulk Insert" command.
Whether I should use SSIS or some other more efficient way to import this data and what its limitations are
Sincerely yours.
2
It depends my dear !. If you use today Bulk Insert to load a certain table, I see no problem. The 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 Source Systems, among others.). In short, we can say: Use Bulk Insert to load a table for repositories and use SSIS for a more elaborate data adaptation.
Thank you for the clarification on the subject. Really it is something very subjective but I managed to form an opinion on the method we adopted.
Browser other questions tagged c# sql importing ssis
You are not signed in. Login or sign up in order to post.
There is no such dichotomy. Use what best solves your problem. I have the impression that this question is based on opinion. I doubt that any answer can add anything useful here, at least in the current form. If it were some concrete case well defined it would be different.
– Maniero
Yes, you’re right. Anyway thank you for your help.
– gvl32