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

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

Getting your SSIS custom extensions to be supported by the multi-version support of SSDT 2015 for SQL Server 2016

We recently released the multi-version support (also known as One Designer) in SSDT 2015, which allows SSIS developers to author, execute, deploy and debug multiple versions of SSIS package from a single version of SSDT designer. With the latest SSDT 2015, SSIS developers can switch the “Target Server Version” property to specify the version of…

0

SQL Server 2016 Documentation Survey

The SQL Server documentation team is working to improve the documentation, to help you be successful with and gain more value from SQL Server. Please consider taking this 9-question survey to send us your thoughts on how we can improve the documentation for you. We are listening to your feedback. The survey closes on March 18th! Thank you.     Posting on behalf…

0

Validate XML with rich error output in the XML Task

  Validate XML documents and get rich error output by enabling the ValidationDetails property of the XML Task. For more info, see Validate XML with the XML Task in the SSIS documentation. SQL Server Integration Services (SSIS) introduced the ValidationDetails property in SQL Server 2012 Service Pack 2 in July of 2014. This new property was…

1