SQL Server 2017 Integration Services Cookbook

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
   • Value: AirportInfo_{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.

6. In the Select Script Component Type dialog, select Destination, as shown in the following screenshot: ...