Coming soon to Premium Level: Intelligent Data Integration Using Hashed Incremental Loads. Also coming soon: A price hike. Enjoy this 2:20 preview and then visit the Premium Level page to sign up (before the price goes up). :{>
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
The SSIS Catalog is Not Available on Linux
At the time of this writing, it is possible to execute SSIS packages on Linux but the SSIS Catalog is not available on Linux – according to the SSIS Catalog Microsoft documentation: But it is possible to execute SSIS on Linux. Learn more! Peace.
SSIS Catalog Browser v0.9.9.0 is Available
I am excited to announce the latest release of SSIS Catalog Browser! SSIS Catalog Browser version 0.9.9.0 is free and features enhanced Folder, Project, and Package Properties, surfacing Description, Validation Status, and Last Validation Time properties: These same properties – Description, Validation Status, and Last Validation Time – are now also included in the scripting …
Continue reading SSIS Catalog Browser v0.9.9.0 is Available
SSIS Catalog Compare – More Than Lift and Shift
Would you like to learn more about Data Integration Lifecycle Management (DILM) or DevOps for SSIS? Enjoy this short video describing SSIS Catalog Compare‘s comparing, scripting, and deployment support for SSIS Catalog artifacts: To learn more, contact us.
SSIS Script Error: Cannot Load Script for Execution
If I had a nickel for every time I’ve encountered “Cannot load script for execution,” I’d have a lot of nickels. In this short (7:24) video, I demonstrate the issue and my fix: My Fix For me, the fix is almost always setting the SSIS project’s TargetServerVersion property to the proper version: “Andy, How Did …
Continue reading SSIS Script Error: Cannot Load Script for Execution
Rest In Peace, Brian Moran (Updated)
Update: Emily, Brian’s daughter, has updated Brian’s Facebook page with information about a memorial service 31 Jul. It grieves me to share that my friend and brother, Brian Moran, passed away late last week. Brian was a gifted technologist and businessman. He built a career and reputation as a SQL Server expert through articles in …
Continue reading Rest In Peace, Brian Moran (Updated)
Join me for a SQLBits Replay of Faster SSIS 15 Jul!
I am honored to join viewers for a SQLBits Replay of my session: “Faster SSIS” 15 Jul 2021 at 8:00 PM BST (3:00 PM EDT)! Visit SQLBits for more information! :{>
The Frank and Andy Data Driven Interviews
Frank and I interviewed each other recently. Here’s the LinkedIn embed of Frank interviewing me: Here’s the DataDriven.tv embed of Frank interviewing me: Enjoy!
Announcing SSIS Framework Manager, v1
I am excited to announce the release of SSIS Framework Manager! Alongside SSIS Framework Community Edition – our free and open source execution framework, SSIS Framework Editions – a comparison of Community, Standard, Professional, and Enterprise editions, and SSIS Framework Browser – our free utility that grants read-only access to our SSIS Frameworks; SSIS Framework Manager …
Continue reading Announcing SSIS Framework Manager, v1
New DataDriven Episode – Chris Wexler on Using AI to Protect the Vulnerable
Content Warning: In this show, Frank and Andy interview Chris Wexler of Krunam.co to discuss using AI to classify images containing child sexual content. The work is important. The discussion is not suitable for all ears. Please consider your surroundings before listening. Frank and I recommend headphones for consuming this content. When we record shows, …
Continue reading New DataDriven Episode – Chris Wexler on Using AI to Protect the Vulnerable