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. 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:
  1. Click on OK to confirm the selection. ...

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