Mastering SQL Server 2017

How to do it...

1. In the solution explorer, open (expand) the ETL.DW project and right-click on it to add a new package. Name it FactOrdersToHDPCuster.dtsx.

2. Go to the Parameters tab and add a new parameter:
   • Name: LoadExecutionId
   • Data type: Int64
   • Value: Leave the default value 0
   • Sensitive: Leave the default value False
   • Required: True

3. Add a data flow task on the control flow and name it dft_FactOrders.
4. In the data flow task, drag and drop an OLE DB source. Name it ole_src_DW_vwFactOrders.
5. Double-click on it to open the OLE DB source editor.
6. Set the OLE DB connection manager to cmgr_DW.
7. For data access mode, use the SQL command.
8. Set the SQL command text to the following:

SELECT OrderDate, FirstName, LastName, CompanyName, Category, ProductName, ...