June 26, 2008 at 9:03 am
Hi,
I'm new with SSIS and I learning again...
How can i join txt files and export to a new database or table.
Example:
I have 3 txt files: Sales, Customers, Products
Customers and Products are data from a master table.
So,
Sales only have an ID (Identity) and 2 more ID (CustomerID, ProductID)
I want to create a new table/database with all the information of the three files....
I already read the txt files, after that apply a sort by Customer.Name and Product.Name, but....and now?
What are the correct control to make the join into this 3 files and generate the table...????
Thanks
June 26, 2008 at 2:15 pm
The Merge Join control will generate the joins necessary to link these tables. Using a Merge Join control is similar to writing inner joins.
Check Merge Join in BOL for an example on how to use it.
June 26, 2008 at 5:59 pm
Hi,
If this answer is not related to your requirements, pls ignore.
I guess your SSIS package is for a regular uploads/data feeds to some system. There is nothing wrong in going for some permanent tables which can be used for your processing.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply