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.
SSIS DevOps Tools new version tasks in preview
SSIS DevOps Tools new enhancements: SSIS Build task version 1.* (Preview) Remove the dependency on Visual Studio and SSIS designer. Build task can run on Microsoft-hosted agent or self-hosted agent with Windows OS and .NET framework 4.6.2 or higher. No need of installing out-of-box components. Support protection level EncryptionWithPassword and EncryptionAllWithPassword. SSIS Deploy task version 1.* (Preview) Support protection level EncryptionWithPassword and EncryptionAllWithPassword.You can now skip SSIS package validation (new setting in SSIS extension 3.9)
With the new version of the SSIS extensions (v3.9), you can set an option to skip the validation of SSIS packages during opening. I've collected the information in a blog post: https://workingondata.wordpress.com/2020/08/24/how-to-skip-ssis-package-validation-new-in-ssis-extension-v3-9/ Have fun and faster SSIS development for you! 😉 Wolfgang
Use SSIS to load data in chunks from SQLServer to Excel
This blog provides a solution to use SSIS to load data in chunks from SQLServer to Excel. The sample package has below steps: Read row count of the data to load from SQL Server and save the row count in variable Split the rows to n chunks in a For Loop Container, create an Excel sheet for each chunk and load data in each chunk to Excel sheet
