Using the Script component as a destination

In this recipe, you will design a custom data flow destination by using the Script Component.

You will use the data retrieved by using the source component created in the Using the Script component as a source recipe and export it in JSON format to one or more files.

The acronym JSON stands for JavaScript Object Notation, an open-source format for representing data in human-readable form that can also be consumed by automated processes.

Getting ready

Before you can complete this recipe, you need to complete the Using the Script component as a source recipe.

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