ODBC is supported in SSIS on Linux (SQL Server 2017 CTP 2.1 refresh)

Dear all, We just announced SSIS on Linux CTP2.1 refresh, in this refresh,  besides many other improvements, we add a new feature which are queried by many customers during CTP2.1 – ODBC support. When the package is designed to use the ODBC connection, it will communicate with the ODBC driver manager and drivers installed on…

1

Using SSIS Scale Out to improve the performance of execution log writing

As you may already known, SSIS Scale Out is available in SQL Server vNext CTP1. it provides the capability to parallel package execution by distributing the execution to multiple machines. In addition, you can get better performance of execution log writing from SSIS Scale Out. For the user who is used to using verbose logging…

1

SSIS on Linux is available in SQL Server 2017 CTP2.1

Dear all, I am very pleased to announce that the Linux version SSIS is available in CTP 2.1. Since March 2016 Microsoft announced that SQL Server plan to support Linux platform, SSIS team has been working on any possibility to also support SSIS on Linux OS. Now you can download SQL Server Integration Services CTP…


New Azure Feature Pack Release Updating HDInsight Support

Dear Customers, I’m happy to announce that we have released a new version of SSIS Azure Feature Pack (AFP) highlighting on HDInsight support upgrade. The download links are as follows: AFP for SQL Server 2012 AFP for SQL Server 2014 AFP for SQL Server 2016 AFP for SQL Server vNext Since the introduction of HDInsight…

0

Run PowerShell scripts in SSIS

PowerShell is a powerful task automation tool from Microsoft. With Azure PowerShell cmdlets, you can write PowerShell scripts to automate various Azure-related tasks. It would be quite nice if we can run PowerShell scripts within SSIS. Although SSIS does not provide something like Execute PowerShell Script Task out of the box, it does have an…

0

SSIS Scale Out is available in SQL Server vNext CTP1

Previously, SSIS package execution is limited to a single machine. However, the new feature Scale Out, available in SQL Server vNext CTP1 has broken the limit. Scale Out provides parallel package execution by distributing the executions to multiple machines so that the overall execution time can be significantly reduced. The user is able to submit…

0

Running SSIS on Azure VM (IaaS) – Do more with less money

Hi all, In the SQL PASS Summit of 2016, I presented a session about “Running SSIS on Azure VM – Do more with less money” and it was well received based on the session feedback. Therefore, I am extracting some key content from my SQL PASS presentation and sharing it on this blog so that more SSIS users can…

0

Update for SQL Server Integration Services Feature Pack for Azure with support to Azure Data Lake Store and Azure SQL Data Warehouse

Hi All, We are pleased to announce that an updated version of SQL Server Integration Services Feature Pack for Azure is now available for download. This release mainly has following improvements: Support for Azure Data Lake Store Support for Azure SQL Data Warehouse Here are the download links for the supported versions: SSIS 2012: https://www.microsoft.com/en-us/download/details.aspx?id=47367…

0

SSIS SCALE OUT and the DYNAMICS AX/CRM ONLINE ODATA CONNECTOR with SQL Server VNext CTP1.0

Hi all, I am pleased to announce that you can now download the SQL Server VNext CTP 1.0 to try out the SSIS Scale out feature and Dynamics AX/CRM Online OData Connector. https://msdn.microsoft.com/en-us/library/mt788653.aspx   I would like to hear from you directly if you have any feedback on the feature, especially about the Scale Out as…

1