I have a dat file which consists of thousands of columns which i have to insert into a database. I have to insert the data into multiple datatables. I am looking for the best possible way to do that. I have looked into bulk insert also but is there a better
way? something like normalizing the data in the data access layer and inserting into the tables or creating ssis packages? Any help is highly appreciated.
View Complete Post