The Recording of Configuring and Managing ADF Azure-SSIS Integration Runtimes is Available

Enjoy this recording of Configuring and Managing ADF Azure-SSIS Integration Runtimes! <ShamelessPlug> Need Help Getting Started with ADF? Enterprise Data & Analytics specializes in helping enterprises modernize their data engineering by lifting and shifting SSIS from on-premises to the cloud. Our experienced engineers grok enterprises of all sizes. We’ve done the hard work for large and challenging data engineering enterprises. …
Continue reading The Recording of Configuring and Managing ADF Azure-SSIS Integration Runtimes is Available

Integration Services Extension for VS 2019 v3.8 Released

The Integration Services v3.8 extension for VS 2019 has been released! From the SQL Server Integration Services Projects page: <ShamelessPlug> Need Help Getting Started with SSIS? Enterprise Data & Analytics specializes in helping enterprises kickstart or complete Enterprise Data Warehouse projects – whether on-premises or in the cloud. Our experienced engineers grok enterprises of all …
Continue reading Integration Services Extension for VS 2019 v3.8 Released

Four Questions to Ask When Hiring an Enterprise Data Consultant

It’s time to hire a consultant for your enterprise data project. That is awesome news, but a quick search for the perfect consultancy reveals a number of options (and hourly rates). What’s a CEO, CIO, CFO, VP, or Director to do? How do you choose a consultant with the right experience for your enterprise data …
Continue reading Four Questions to Ask When Hiring an Enterprise Data Consultant

The SSIS Catalog and SCCPAC Files

The SSIS Catalog is a pretty cool SSIS framework, whether installed on-premises or in the cloud (Azure-SSIS). Practicing lifecycle management with the SSIS Catalog can be… challenging. Try scripting an existing SSIS Catalog Environment after creation, for example: The result? Sad trombone… SCCPAC Files to the Rescue! SSIS Catalog Compare Enterprise Edition includes SCCPAC file …
Continue reading The SSIS Catalog and SCCPAC Files

On Installing Integration Services Versions Side-by-Side

I do not recommend installing Integration Services versions side-by-side. Microsoft provides an article describing how to accomplish side-by-side installation of Integration Services, but the article has not been updated in over three years and the last SSIS version mentioned is 2016. Over the years, I have helped customers who have more than one version of …
Continue reading On Installing Integration Services Versions Side-by-Side

Learn Azure Data Factory and SSIS and Save Money!

I am excited to announce two additional live, online training deliveries: SSIS Data Flows – 27-28 May 2020 SSIS Administration – 02-03 Jun 2020. Note: SSIS Data Flows is a prerequisite for SSIS Administration. SSIS Data Flows is the first two days of my four-day live, online From Zero To SSIS course – which I …
Continue reading Learn Azure Data Factory and SSIS and Save Money!