SSIS Merge two CSV Files
Posted on 2010-09-15
Please would someone be able to help me, i have two CSV files that i wish to merge by one column (partcode)
CSV 1 has: partcode, manufacturer, description, costprice, rrp
CSV2 has: partcode, stock
i need them to be merged by partcode for each item (the stock list has items that arent in the csv1)
i have used a merge join with an inner join which works but only does 6 rows when there are 359 rows in the file.
does anyone know how i can get this to work.
e.g. if part code matches then insert stock to csv1 file.