Using the Script component as a source

In this recipe, you will create a custom source by using the Script Component as a data flow source.

You will connect to a web service and retrieve the data from it, which you will then place into the data flow pipeline.

How to do it...

1. Add a new SSIS package to the AdventureWorksETL project you created at the beginning of this chapter.
2. Change the name of the newly created package to CustomWebServiceSource.dtsx and save it.
3. Make sure the CustomWebServiceSource.dtsx package is active, and then create a new package parameter using the following settings:
   • Property: Value
   • Name: CountryName
   • Data type: String
   • Value: France
4. Drag a Data Flow task to the control flow designer and change its name to Airport Information.
5. Open the Airport Information task in the data flow designer and drag a Script Component to the data flow designer.
6. In the Select Script Component Type dialog, select Source, as shown in the following screenshot:

7. Click on OK to confirm the selection.
8. Change...