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. In SSDT, add a new package to the Chapter08 SSIS project. Name it TermExtactionLookup.
  2. On the Control Flow tab in the Package Designer, add two data flow tasks. Name them TermExtraction and TermLookup and connect them with the green arrow. The term extraction task should be first.
  3. Click the Data Flow tab. Select the TermExtraction task. Prepare the data flow for this task.
  4. Add a flat file source. Name it ImportBlogs. Set the properties for this source:
    • Create a new connection manager called BlogsTxt, whose source file is C:\SSIS2016Cookbook\Blogs.txt. Select the column names that are in the first data row checkbox.
    • Click Columns. Check whether you see the data in tabular format with three columns and five rows. The columns ...

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