Articles

Technical Article

Setting Up Email Notification for SSIS Package Failure

As a DBA, we often setup monitoring to receive job failure notification, but when it comes to SSIS packages, we either do not capture the job failure (if the job runs through the command prompt) or we have no idea why it failed. In this article, I'd like to walk you through how to enable the logging functionality for SQL Server Integration Services (SSIS) and how to capture detailed information for immediate troubleshooting without "re-run" the package.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2012-01-18

2,927 reads

SQLServerCentral Article

A script task alternative to a massive SSIS multicast transformation

A Multicast Transformation can be used to write the same data file to multiple network folders, but it can be tedious and time-consuming to set up as the number of destination files grows. Learn how you can use this transformation in this article by Stan Kulp.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(15)

You rated this post out of 5. Change rating

2012-01-17

4,657 reads

External Article

Grant Fritchey's SQL Server Howlers

We decided to ask various well-known SQL Server people to write about their favorite SQL Server Howlers. These are those common misunderstandings about how SQL Server works that end in tears, and plaintive forum questions. Grant Fritchey opens the series with some of those howlers that stick in the mind.

2012-01-12

4,268 reads

Blogs

T-SQL Tuesday #202: 100 Hours

By

It’s time for T-SQL Tuesday again and this is a great prompt to start...

T-SQL Tuesday

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search

By

How I used AI for this postChatGPT to generate images based on info specifically...

Read the latest Blogs

Forums

Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform

By mehul.bhuva@gmail.com

Comments posted to this topic are about the item Databricks Genie Spaces for SQL...

The Costs of Multiple Platforms

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Costs of Multiple Platforms

RegEx Functions II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item RegEx Functions II

Visit the forum

Question of the Day

RegEx Functions II

I have this data in a table in a SQL Server 2025 database: 

EmailAddressID EmailAddress
7              dylan0@ADVENTURE-WORKS.COM
8              Diane1@ADVENTURE-WORKS.COM
If I run this query, which row(s) are returned? 
SELECT top 10
 *
 FROM person.EmailAddress
 WHERE REGEXP_LIKE(EmailAddress, '^d')
 AND BusinessEntityID IN (7,8)

See possible answers