Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Multiple Look Up & Source File Compare
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

112 Posts

Posted - 09/04/2013 :  13:15:25  Show Profile  Reply with Quote
Got a Transformed Data using SSIS (Pivot, Unpivot and Aggregrate). Need to Join the Transform Output to Other SQL Tables to get the Destination Data.

Ex: TableA (Transformed Output)
[Country] [Brand] [Cat] [Month] [Vol]
IND PG A JAN12 500
IND PG A FEB12 500
IND PG B JAN12 300
IND PG B FEB12 200
IND ET A JAN12 400
IND ET B FEB12 350
IND ET A JAN12 200
IND ET B FEB12 400

Country (ID,NAME) 1-IND
MONTH (ID,MONTH) 0112-JAN12, 0212-FEB12
Product (ID,Brand,Cat) 101 - PG & A, 102 - PG & B, 103 - ET & A, 104 - ET & B

Req.Output: (Joining Above Tables to get the Result with Lookup)
[CountryID] [ProdID] [MonthID] [Vol]
1 101 0112 500
1 101 0212 500
1 102 0112 300
1 102 0212 200
1 103 0112 400
1 103 0212 350
1 104 0112 200
1 104 0212 400

And Above Output need to compare with Existing Table for Duplicates or for any New Products
Please Help me How can I Use the 1st Output in Multiple Lookup and 2nd Output for Compare.

  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000