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...
- Make sure that the
CustomWebServiceSource.dtsx
package of theAdventureWorksETL
solution from theC:\SSIS2016Cookbook\Chapter07\Solution\
folder is active in the control flow editor. - Add a package parameter using the following settings:
Property
:Value
Name
:JSONFilePath
Data type
:String
Value
:C:\SSIS2016Cookbook\Chapter07\Files
- Add another package parameter using the following settings...