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

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