[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1084
  • Last Modified:

SSIS Merge two CSV Files

Hi,

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.

Regards
Sophie

xxx
 
0
sophieb1984
Asked:
sophieb1984
1 Solution
 
brittonvCommented:
Have you considered using a powershell script to do it?
http://www.eggheadcafe.com/software/aspnet/29464678/mergingjoinging-two-files.aspx
0
 
sophieb1984Author Commented:
Thanks so much found the script on the link you sent and it works brilliantly i didnt even know that you could use powershell to do things like this i think i will need to brush up on powershell!!
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now