The Recording for Troubleshooting SSIS (Part 1) is Available

A fantastic crowd attended today’s (13 Mar 2019) free webinar titled Troubleshooting SSIS. If you attended you got the full show. If not, you may view the content at SSIS Academy for a nominal fee. Enjoy this focused content to SSIS Self-Help, a service from Enterprise Data & Analytics designed to help folks quickly and …
Continue reading The Recording for Troubleshooting SSIS (Part 1) is Available

SQL Saturday 813 – Boston #SSIS Precon 29 Mar 2019!

I’m honored to deliver Intelligent Data Integration with SSIS – a full-day pre-conference session – at SQL Saturday 813 in Boston 29 Mar 2019! What is Intelligent Data Integration?SSIS (SQL Server Integration Services) packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM (Data Integration Lifecycle Management), produced using …
Continue reading SQL Saturday 813 – Boston #SSIS Precon 29 Mar 2019!

Enterprise Data & Analytics Welcomes Eugene Meidinger!

I am honored and thrilled to welcome Eugene Meidinger (@SQLGene | blog | LinkedIn | Pluralsight) to the Enterprise Data & Analytics team! Eugene is self-described as a Business Intelligence Consultant but I think he’s being modest (in my humble opinion… see what I did there?). Eugene has authored three Pluralsight courses on the topics Power BI, DAX, Power Pivot, and SSAS. His …
Continue reading Enterprise Data & Analytics Welcomes Eugene Meidinger!

SSIS Project Connection Manager Naming Error

I am sometimes asked, “Andy, how do I start a technical blog?” I demonstrate one way here – a way that has served me well with search engines. 1. Describe how the error occurred.2. Copy the error message, post it as text.  3. Describe the solution. I am helping a large enterprise client migrate their data integration …
Continue reading SSIS Project Connection Manager Naming Error

Start Azure-SSIS, Execute Package, Stop Azure-SSIS

Last August, I had a blast at the Data Platform Summit 2018 in Bengaluru, India. One highlight of the trip was meeting and conversing with the Azure Data Factory SSIS Integration Runtime Product/Program Manager, Sandy Winarko. Sandy and I swapped coder stories and talked about data integration design patterns and I learned a few new …
Continue reading Start Azure-SSIS, Execute Package, Stop Azure-SSIS

SSIS Catalog Compare Version 4 – Three Videos

I am excited to announce general availability of SSIS Catalog Compare version 4! I made three short-ish (~2 minutes each) videos demonstrating some of the capabilities of the product. I really like the SCCPAC files and SCCPAC Deployment Wizard, which are only available in the Enterprise Edition. Use SCCPAC Deployment Wizard to Lift and Shift …
Continue reading SSIS Catalog Compare Version 4 – Three Videos

Grant SSIS Catalog Read-Only Permissions

The SSIS Catalog has built-in security to manage permissions. SSISDB – the database behind the SSIS Catalog – is “just a database” in many respects. When it comes to security, the SSIS Catalog surfaces an internal mechanism that provides granular permissions management. In this post I intend to demonstrate how to use SSIS Catalog security to …
Continue reading Grant SSIS Catalog Read-Only Permissions

Two ADF Presentations Next Week!

I am honored to deliver Moving Data with Azure Data Factory to two User Groups next week! Abstract Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical user interface) and supports the SSIS Integration Runtime (IR) – or “SSIS in the Cloud.” Attend this session …
Continue reading Two ADF Presentations Next Week!