This error frequently arises when the OAuth flow hasn't been initialized. It's important to note that while this issue is more common in SSIS it is not limited to SSIS components only; it can also occur in various editions. However, the InitiateOAuth connection property within SSIS components may not always be readily visible for configuration.
To resolve this error, navigate to the Advanced tab and locate the OAuth section. Within this section, you will find the Initiate OAuth connection property. Depending on your specific use case, set this property to either GETANDREFRESH or REFRESH.
GETANDREFRESH: Indicates that the entire OAuth Flow will be handled by the component. If no token currently exists, it will be obtained by prompting the user via the browser. If a token exists, it will be refreshed when applicable.
REFRESH: Indicates that the component will only handle refreshing the OAuthAccessToken. The user will never be prompted by the component to authenticate via the browser. The user must handle obtaining the OAuthAccessToken and OAuthRefreshToken initially.
Please reach out to firstname.lastname@example.org if this does not resolve the problem for you.