Trying to connect to ADO via oData in SSIS - getting 401 Unauthorized
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: https://analytics.dev.azure.com/*****/***/_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.
Azure maps geocoding and SSIS
Can someone offer pointers on integrating Azure maps geocoding capabilities in SSIS? Is their a more streamlined way of leveraging this than creating a C# script component within SSIS? I've not used Data Factory before - but wondering if that would be an elegant way of handling this. End goal is attaching lat/longitude values to address information in SQL Server database. TIA
Data Migration from Sql DataBase to Azure Data Lake Using SSIS
Hi, how are you? I want to migrate data from SQL DataBase (on-premises) to Azure Data Lake (Cloud) Using SSIS(SQL Server Integration Services) how I can do this and please also guide me I have massive data so which one will best practice to migrate data from SQL DataBase to Azure Data Lake Using SSIS.