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?
If the staging area DB is on the same server as the DW DB, you can use an Execute SQL task to insert the records in to the C table.
If not, then just use the table C query as the command source for a data flow.
Russel Loski, MCT, MCSA SQL Server 2012, 2008, MCITP Business Intelligence Developer and Database Developer 2008 Twitter: @sqlmovers; blog: www.sqlmovers.com