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.
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.
