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
Operationalize your machine learning project using SQL Server 2016 SSIS and R Services
First published on MSDN on Jan 11, 2016 With the release of CTP3 SQL Server 2016 and its native In-database support for the open source R language (SQL Server R Services), users can now call both R and RevoScaleR functions and scripts directly from within a SQL query and benefit from multi-threaded and multi-core in-DB computations.
