A new OData Source for SSIS is now available. The 2012 version is available as a standalone download, and the 2014 version is part of […]
Generate an Empty Raw File Without Running your SSIS Package
A new feature was added to the Raw File Destination in SQL Server 2012 which allows you to output an empty raw file from the […]
Using Hive ODBC from SSIS
Microsoft announced the general availability of Windows Azure HDInsight last week, and released an updated version of the Microsoft Hive ODBC Driver. This post describes […]
Links from the SSIS Roadmap Session
Here are some of the resources I mentioned in the SSIS Roadmap session at the PASS Summit. SSIS Reporting Pack from Jamie Thomson DQS […]
SSIS Content from PASS Summit 2013 on PASS TV
You can now stream sessions from the 2013 PASS Summit on-demand from the PASStv site. There’s a lot of amazing content on there, including the […]
SQL Server Data Tools – Business Intelligence downloads
(update 2014/11/14: added link to the VS 2013 release which came out in April) Looking for the SSIS development tools? Formerly known as Business Intelligence […]
SELECT * From SSIS.DataFlow
If you’ve been looking through the documentation for the Power BI preview, you might have noticed a section on Publishing SSIS Packages as OData Feeds. […]
Server Execution Parameters with DTEXEC
The SSIS team blogged about executing packages deployed to the SSIS Catalog using DTEXEC a while ago. The post mentions the $ServerOption::SYNCHRONIZED parameter as a […]
SQL Saturday Dublin – this weekend!
Less than a week to go before the next SQL Saturday Dublin event! I’ll be presenting a fun session at the main event (Cats, Facebook, […]