How to design your SSIS package with ODBC connection on Windows and run it on Linux?

First published on MSDN on Jul 13, 2017

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 pack… Continue reading How to design your SSIS package with ODBC connection on Windows and run it on Linux?

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

First published on MSDN on Jun 15, 2017

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 mach… Continue reading Using SSIS Scale Out to improve the performance of execution log writing

if you face an issue when the Attunity connectors aren’t visible in the SSIS Toolbox…

First published on MSDN on May 22, 2017

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 Tool… Continue reading if you face an issue when the Attunity connectors aren’t visible in the SSIS Toolbox…