The puzzle that I have been presented is to create a Script component that pulls data from a web service that only OAuth2 Authentication.
I have examples of a Script Component that retrieves data from another web service that uses basic authentication.
To be fair, C# Script components in SSIS are not a specialty of mine. However, I can do some basic C# coding in scripts to accomplish simple tasks.
Has anyone been successful in writing an SSIS Script Component using OAuth2 authentication using C#?