How to do it...

  1. Make sure that the CustomWebServiceSource.dtsx package of the AdventureWorksETL solution from the C:\SSIS2016Cookbook\Chapter07\Solution\ folder is active in the control flow editor.
  2. Add a package parameter using the following settings:
    • Property: Value
    • Name: JSONFilePath
    • Data type: String
    • Value: C:\SSIS2016Cookbook\Chapter07\Files
  3. Add another package parameter using the following settings:
    • Property: Value
    • Name: JSONFileNameFormat
    • Data type: String
    • ValueAirportInfo_{0:D3}.JSON
  4. Open the Airport Information data flow in the data flow designer.
  5. Form the SSIS Toolbox, drag a Script Component to the data flow designer.
  1. In the Select Script Component Type dialog, select Destination, as shown in the following screenshot: ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.