I am honored to announce the latest addition to DILM Suite, another free and open-source project named SSIS Framework Community Edition 2022! SSIS Framework CE 2022 is an updated version of SSIS Framework Community Edition – which is also free and open-source – but features a separate database, named SSISFrameworkDB, for storing SSIS Application and Package …
Continue reading Announcing SSIS Framework Community Edition 2022
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, Azure Data Factory, SSIS guy, and farmer. I was cloud before cloud was cool. :{>
Install and Configure SSIS Catalog Archive
Yesterday (27 Dec 2021), I streamed Introducing SSIS Catalog Archive. Since then, I’ve finished the first draft of documentation. Today (28 Dec 2021) I streamed about configuring SSIS Catalog Archive – a free and open-source project I designed to support managing the SSIS Catalog log tables. Links in today’s stream: SSIS Catalog Archive @ github …
Continue reading Install and Configure SSIS Catalog Archive
Introducing SSIS Catalog Archive
I had some free time over the holidays, so I designed a beta version of SSIS Catalog Archive. You can watch the video below. You can browse to my github repo and check it out. It’s beta… and I may be stretching the definition of “beta” a bit here. Enjoy! Learn More Check out upcoming …
Continue reading Introducing SSIS Catalog Archive
SSIS Catalog Reports – Operations Report
I recently added an Operations Report to DILM Suite‘s SSIS Catalog Reports solution. To acquire your very own copy of SSIS Catalog Reports – a free and open-source SQL Server Reporting Services (SSRS) solution – visit DILM Suite: Scroll until you find the link to SSIS Catalog Reports, and then click the link: The new …
Continue reading SSIS Catalog Reports – Operations Report
AndyStream for 20 Dec 2021
I streamed! Links from Today’s Stream: SSIS Catalog Execution Ended Unexpectedly How to Stand Out and Gain Followers on Social Media Documenting an SSIS Lift and Shift Project Subscribe to Andy’s Mailing List! Sponsored by: Join Me for LIVE Online SSIS and ADF Training 29 Nov – 1 Dec Sponsored by: The Data Channel Enjoy!
SSIS Catalog Execution Ended Unexpectedly
There are a handful of reasons for an “Ended Unexpectedly” package execution status in the SSIS Catalog. One reason is: the SSIS package was reporting a “Running” status when the SQL Server instance started. I can hear some of you thinking,… “How Did I Get Here?” The day earlier, I was testing some new SSIS …
Continue reading SSIS Catalog Execution Ended Unexpectedly
How to Stand Out and Gain Followers on Social Media
How’s that for click bait? Does Unsolicited Stuff Bother You? I have to admit, some unsolicited stuff bothers me. It’s one thing if I sign up for a newsletter or follow an account. It’s different if someone visits a contact form on my site and spams me. I have a personal rule to never, ever, …
Continue reading How to Stand Out and Gain Followers on Social Media
Documenting an SSIS Lift and Shift Project
I was honored to work on a cool SSIS lift and shift project in 2021. I will not mention project details or the client. I will share that I’ve worked with the team before and that they are awesome and talented and easy to work for (and with). The company is large. Like international-large. I, …
Continue reading Documenting an SSIS Lift and Shift Project
New Introduction to Azure Data Factory Tutorial at The Data Channel
Frank did an awesome job editing our latest tutorial at The Data Channel – Getting Started with Azure and Azure Data Factory. It’s part of a series we call “Andy Leonard Shows You How.” I think that’s a pretty snappy label for the series, but I am definitely biased. Here’s a screenshot of me being …
Continue reading New Introduction to Azure Data Factory Tutorial at The Data Channel
Expert SSIS Training, Live and Online 17-18 Jan 2022
I am excited to announce the next live and online delivery of Expert SSIS is 17-18 Jan 2022! Use the coupon code LimitedTimeDiscountExpertSSIS and save! Course Description Data integration is the foundation of data science, business intelligence, and enterprise data warehousing. This instructor-led training class is specifically designed for SQL Server Integration Services (SSIS) professionals responsible for …
Continue reading Expert SSIS Training, Live and Online 17-18 Jan 2022