As we continue our march towards General Availability (GA) of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF), we are excited to announce the release of Execute SSIS Package activity as the most direct and code-free method to invoke SSIS package executions within ADF pipelines. In the past, our customers resorted to…

As we continue our march towards General Availability (GA) of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF), we are excited to announce the release of three interrelated features for Public Preview: Enterprise Edition, Custom Setup, and 3rd Party Extensibility for Azure-SSIS Integration Runtime (IR). Enterprise Edition The Enterprise Edition of Azure-SSIS…

Hi all, Do you want to simply take your on-premises SSIS packages and run it on a fully managed services on Azure? Wait no more! We have now released the public preview of ADF V2, which has the capability for executing SSIS packages on Azure. please check out these announcement blogs for details. https://azure.microsoft.com/en-us/blog/azure-data-factory-announcing-new-capabilities-in-public-preview/ https://blogs.technet.microsoft.com/dataplatforminsider/2017/09/25/microsoft-for-the-modern-data-estate/…

Dear SSIS Users, I’m happy to announce that we have released a new version of SSIS Azure Feature Pack, strengthening the connectivity for Azure Data Lake Store (ADLS). Below is the list of improvements for this release: Azure Data Lake Store File System Task: This task is designed to provide users the capability to perform file…

Hi all, I’m pleased to announce that the first preview version of SSIS designer for Visual Studio 2017 is now available! This is a new milestone of SSIS designer. VS2017 is quite different with previous versions, which requires us to spend much more time and effort to fit our designer into the new VS. Now…

Dear all, I am very pleased to announce that SSIS on Linux supports RedHat in SQL Server 2017 RC1. Besides Ubuntu, you can install SSIS on RedHat and execute your packages. If you have any feedbacks on it, please email me directly (lle@microsoft.com). Install SSIS on RedHat To install the mssql-server-is Package on RedHat, follow…

Before we start, let us consider below questions: As SSDT is not supported on Linux, we have to design SSIS packages on Windows. But do we need to make any changes on these packages before we run them on Linux? If we would like to use ODBC to connect any databases like Oracle, MySQL on…

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…

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…

To see the Attunity connectors in the SSIS Toolbox, you always have to install the version of the connectors that targets the same version of SQL Server as the version of SQL Server Data Tools (SSDT) installed on your computer. (You may also have earlier versions of the connectors installed.) This requirement is independent of…