This article is here to help our banking clients

Create a table to hold bank holidays

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

Create SQL script in AETL

skip bank holiday sql

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

Create a package

skip bank holiday package

This simple solution allows the to skip package execution on bank holidays.
Download Advanced ETL Processor Enterprise now!

We have 178 guests and no members online