O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required