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

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

Kalaiselvan
Posting Yak Master

India
110 Posts

Posted - 09/04/2013 :  13:15:25  Show Profile  Reply with Quote
Hi,
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.



Regards,
Kalai
  Previous Topic Topic Next Topic  
 New 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