I´m new using SSIS so I need help - thanks!
I´ve too tables A and B, and I need to create a C table with information of one of the tables.
Table A query
Table B query
Table C query
SELECT P.[PRODUCT_CODE], P.[DESCRIPTION], P.[PRODUCT_GROUP_ID], G.[DESCRIPTION] DESCPROD, P.[PRODUCT_GENDER], P.[SEASON]
FROM [DATA].[D_PRODUCT] P, [DATA].[D_PRODUCT_GROUP] G
WHERE P.[PRODUCT_GROUP_ID] = G.[PRODUCT_GROUP_ID]
I need your help to learn how to implement this in SSIS?
The information off the A table is in a Flat File A.
The information off the B table is in a Flat File B.
- I already read the A ff and put the data into a A table - in the satging area DB,
- I already read the B ff and put the data into a B table - in the satging area DB,
Now, what do I´ve to do to put the information I need in one C table in the DW DB?