Skipping ETL transformation execution on bank holidays

Company news, product updates, and practical articles from DB Software Laboratory.

Advanced ETL Processor
4.9 ★★★★★ Based on 16 reviews on Capterra See all reviews on Capterra →
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

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.

Next step

See the related product page for current features, editions, and trial downloads.

View Advanced ETL Processor EnterpriseDownload trial

Direct link, no registration required.

Related Resources

Advanced ETL Processor Enterprise Review the Advanced ETL Processor Enterprise product page. Articles Library Browse more etl guides articles. WIKI Read product documentation and implementation notes.

By DB Software Laboratory Last updated