REST API through SSIS

• rocky_498

  SSCertifiable

  Points: 6532

  More actions

  October 25, 2020 at 6:58 am

  #3800859

  I want to call (REST) API the "GET" command and assign the return value to the variable through SSIS.

  Any advice.

  Thanks,

  -ak

• Phil Parkin

  SSC Guru

  Points: 247140

  More actions

  October 25, 2020 at 4:51 pm

  #3801022

  I've done this before, using a Script Component source.

  You'll find articles online from others who have done this before. Here is an example.

  ---

• rocky_498

  SSCertifiable

  Points: 6532

  More actions

  October 29, 2020 at 2:30 am

  #3802303

  Thanks, Phil. Let me take a peek.