Mastering SQL Server 2017

How to do it...

1. Make sure that the CustomWebServiceSource.dtsx package of the AdventureWorksETL solution from the C:\SSIS2016Cookbook\Chapter11\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\Chapter11\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: ...