Skipping ETL transformation execution on bank holidays
Company news, product updates, and practical articles from DB Software Laboratory.
ETL Guides DB Software Laboratory
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

SELECT COUNT(*)
AS C
FROM [BANK_HOLIDAS]
WHERE CONVERT(date,
[BANK_HOLIDAY]) = CONVERT(date,
getdate())
3. Create a package

This simple solution allows the to skip package execution on bank holidays. Next step
See the related product page for current features, editions, and trial downloads.
Direct link, no registration required.
By DB Software Laboratory • Last updated