Continuation from the previous 76 parts, the whole series can be found at https://www.nikoport.com/columnstore/ I have written previously about SQL Server Integration Services and their interaction with Columnstore Indexes in Columnstore Indexes – part 51 (“SSIS, DataFlow & Max Buffer…
SSIS 2012 Design Patterns by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss and Michelle Ufford
During my vacations at the end of 2014 I have finally finished a book on “SQL Server 2012 Integration Services Design Patterns”. This book is written by some of the most respected authors in the SSIS space, such as Andy…
SSIS ReportGenerator Task
Did you ever faced a situation when needing to generate dynamically a SQL Server Reporting Services Report on-demand, at some strange hour, such as 4:30 AM because of the different timezones involved or because it takes so much time and…
SSIS GoogleAnalyticsSource 1.7
A couple of days ago, Tillmann has released a new version of his amazing SSIS data source for Google Analytics – GoogleAnalyticSource. After 5 months and some extensive investments here are some of the news that this release contains: Support…
SSIS Project Deployment under different name
I love SSIS Server, it was one of the greatest addition to the SQL Server Integration Services in 2012 version without any doubt, even though the RTM bits were not production ready. There is one issue with the SSIS Project…