Trying to connect to ADO via oData in SSIS - getting 401 Unauthorized

Copper Contributor

I'm trying to pull some data from ADO online using the oData connector in SSIS (Visual Studio 2019 and SSDT - all on latest versions).   Using this URL (redacted our site info), and it works without issue in the browser:*****/***/_odata/v4.0-preview/WorkItems 


But when I add an OData Source into an SSIS Data Flow no matter which authentication method I use I get 401 Unauthorized.  Can someone give any insight on what I may be missing?  Thanks.

0 Replies