I have been supplied a 200 MB text file in segemnts which I need to load at Sql server using some utility. I have done it years earlier using BCP at SQL 2000 and not sure if I need to use SSIS here?
I don't have much exposure to SSIS or data loading so could someone point me to a very good written example? Is there anything simpler which could be used?
The Char fields may have " to show them they are char and not numbers.
I may also have to omit some column values in file may not required in target MSSQL table.
Is it possible to split data columns into normalised tables? I mean read one text file and load data at 3 different tables?