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. Make sure that the RegExValidation.dtsx package is active in the control flow designer.
  2. Right-click in the empty canvas of the Connection Managers pane at the bottom of the SSDT window and select New Flat File Connection... from the shortcut menu.
  3. Use the Flat File Connection Manager Editor to create a new connection manager, and on the General page enter PersonData into the Connection manager name textbox.
  4. To determine the File name property, click Browse..., and then select the Ch07_PersonData.csv file in the C:\SSIS2016Cookbook\Chapter07\Files\ folder.

The file should be recognized as a Unicode file automatically; otherwise, check the Unicode option below the Browse... button.

  1. Leave the rest of the properties unchanged, ...

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