November 21, 2011 at 5:55 pm
Hello,
I'll try and keep this simple.
I have an XML file, 2 nodes of which I'm concerning about. A 'Supplier' Node listing their products, and an 'Attributes' node. Simply put, there are attributes to every Product produced by a supplier.
There's only one field that could possibly link the two together, and that's Product_ID. However, multiple suppliers will have a product_id of 1, thus making the join in T-SQL tables impossible.
Does SSIS in BIDS (which I'm relatively new too) have a function/feature/transformation, where by I can populate an Attributes table with all of it's corresponding data, while also inserting the supplier_id as an extra column.
The supplier_id needs to come from the supplier node, while 'joining' the attributes table; so to speak.
You would think this is somehow possible, based on the fact that the attributes node is always a node within the supplier node.
Any help or guidance would be much appreciated.
Cheers,
-Ro
November 22, 2011 at 10:43 am
I found an answer.
I had to use the 'Merge Join' Data Tranformation in BIDS to ge this to work.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply