This article is here to help our banking clients

1. Create a table to hold the list of bank holidays

CREATE TABLE [dbo].[BANK_HOLIDAS](
    [BANK_HOLIDAY] [date] NULL
) ON [PRIMARY]
GO

2. Create SQL script in AETL

skip bank holiday sql

SELECT COUNT(*) AS C  FROM [BANK_HOLIDAS]
WHERE CONVERT(date, [BANK_HOLIDAY]) = CONVERT(date, getdate())

3. Create a package

skip bank holiday package

This simple solution allows the to skip package execution on bank holidays.
Direct link, no registration required.