I have two .csv files.
The data in 1 of the .csv files has to be manipulated and converted into another .csv file.
The columns are different in each of the files.
Is the best way to do this using SQL Server SSIS? Or is there another easier way?
Just FYI... I have SQL Server 2008 R2.
Thanks a lot in advance,