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

Using SSIS to load 1TB data into SQL Server in 30 mins, with simplified settings

Figure_2
Figure_2

In 2008, SSIS team posted a blog about loading 1TB data in 30 minutes, and after 8 years, hardware and software are rapidly improved, now we are doing similar experiment with only on two servers which can achieve same performance. In our experiment, we use the latest SSIS 2016 and we can load 1TB data…

0

Different approaches to inject data into Azure SQL Data Warehouse

Different approaches to inject data into Azure SQL Data Warehouse For the SQL Data Warehouse customers, the primary objective when migrating data is to populate their SQL Data Warehouse database. This process can be achieved in a number of ways, SQL Server Integration Services(SSIS) supports 3 different approaches to inject data into SQL Data Warehouse…

1

SSIS 2016 PDW connector for SQL Server 2016 with AU5 is now available for download!!

Hi all, I am pleased to announce that the SSIS 2016 PDW connector for SQL Server 2016 with AU5 is now available for download!! https://www.microsoft.com/en-us/download/details.aspx?id=51610&wa=wsignin1.0 This PDW SSIS destination connector is designed specifically for building and running Integration Services packages that load data into PDW. Thanks jimmy  

0

Update for SQL server Integration Services Feature Pack for Azure with support to Azure Moon cake and New Blob Storage account

Hi All,   We are pleased to announce that an updated version of SQL server Integration Services Feature pack for azure is available now for download. This release mainly has following improvements: 1.       Support for Azure moon cake, the customers can now seamlessly connect to azure moon cake from SQL Server Integration services 2.       Support…

0