Author: JimmyWongMS

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: JimmyWongMS. 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 the version of SQL Server that you want to target in your SSIS projects and packages.+ For example, if you’ve installed the latest version of SSDT, you have version 17 of SSDT with a build ... Read More

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: JimmyWongMS. 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 benefit from it. Why running SSIS on Azure VM? Pay per use with support of BYOL Elasticity with cost options (1 Core 2GB 1TB -> 32 Core 512GB 64TB) Extremely Secure at physical/infrastructure/SQL level Reliable storage ... Read More

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: JimmyWongMS. 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 this is one of our key enterprise investment for SSIS VNext. Please email me directly at jwong@microsoft.com with your feedbacks. Enjoy!   Support Scale Out of SSISThe Scale Out feature makes it much easier to ... Read More

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   ... Read More

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 for connecting to new Blob storage which was released recently. See article1 and article2 for details 3.       Added feature improvement to support Compression/Decompression in Azure blob source/Destination components for text format.   Here are the download links for the supported versions: SSIS 2012: https://www.microsoft.com/en-us/download/details.aspx?id=47367 SSIS ... Read More

Hi all,   With the SSIS 2016 officially released in May 2016, I am now pleased to announce that the Microsoft Connectors 4.0 for Oracle and Teradata is also available for SSIS 2016. We worked really hard to get this out on time to align with the SSIS 2016 RTM time, so that you do not have to wait anymore in case you need this connectors 4.0 when moving to SSIS 2016. This connectors add additional supports for Oracle 12.c and Teradata 15 / 15.1. Enjoy!   Download link: https://www.microsoft.com/en-us/download/details.aspx?id=52950   Thanks   Jimmy SSIS Team ... Read More

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 which SSIS package is executed and deployed on. Today, we will show you how to get your custom extensions to be supported by the multi-version support in SSDT 2015. Having your assemblies in the appropriate folder First, you need to make sure you build your ... Read More

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 of Carla Sabotta SQL Server Documentation Team ... Read More

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 not announced or documented at the time of its original release. The property is also available in SQL Server 2014 and in SQL Server 2016. The following screen shot shows the XML Task Editor with the settings required for XML validation with rich error output.   ... Read More

Hi all, The SQL Server 2016 RC0 will be out anytime soon. A preview for the SSIS community here Below is the specific improvements we added for RC0: SSIS Hadoop connector now supports ORC format. SSIS SSDT multi-version support targeting SQL versions 2012, 2014 and 2016 (One Designer) Below are some SSIS SSDT multi-version support Known issues for RC0: SQL 2016 Project connection manager UI is used when switching to 2014. Create project level connection manager in 2014, Switch target server version to sql server 2016, then switch back to SQL server 2014, the project connection manager UI is still ... Read More