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

The JSON File destination receives the rows from the upstream component, stores them in a variable (50 rows at a time), and converts the row set into a JSON document, which it then loads into a file in the file system.

The JSONFileInput_ProcessInput method contains all the logic needed to process the incoming pipeline data; it creates batches of up to 50 rows so that no resulting JSON document contains more than 50 items.

The WriteJSONFile function uses the Serialize() method of the JavaScriptSerializer class to create a JSON document from the row set, and the metadata needed to create the document's structure is provided by the AirportInfo class.

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