SQL Server 2017 Integration Services Cookbook

How to do it...

1. Add a new package to the Chapter08 project. Rename it DataMining.dtsx.
2. In the control flow of the package, add a new data flow task by dragging it from the SSIS toolbox to the control flow work area.
3. Click the Data Flow tab to open the Data Flow Designer.
4. Create a new OLE DB source. Name it TMTestSet. Double-click the TMTestSet data source.
5. On the General tab, create a new connection manager. Use the AdventureWorksDW2014 database on your SQL Server instance.
6. Select the Table or view option in the Data access mode drop-down list.
7. Select the dbo.TMTestSet table.
8. Click the Columns row in the left-hand list to check the mapping between the input and output columns. Leave the default mappings.
9. Add the data mining query transformation ...