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

Get SQL Server 2017 Integration Services Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial