Solved

SSIS Merge two CSV Files

Posted on 2010-09-15
2
1,072 Views
Last Modified: 2012-05-10
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
Comment
Question by:sophieb1984
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 8

Accepted Solution

by:
brittonv earned 500 total points
ID: 33683173
Have you considered using a powershell script to do it?
http://www.eggheadcafe.com/software/aspnet/29464678/mergingjoinging-two-files.aspx
0
 
LVL 1

Author Closing Comment

by:sophieb1984
ID: 33699354
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how the fundamental information of how to create a table.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question