Richard Douglas – SQL Server Professional

Adding notification messages in SSIS is really quite easy once you understand how you can use expressions, one of my pet hates is receiving process notification emails that contain things like " file(s) processed" or " record(s) processed".

So, now we have a scenario with a disgruntled user how do we create a more professional looking solution? [...]

One of the things I love best about SQL Server Integration Services (SSIS) is how powerful expressions are. In this blog I will talk about how you can enable SSIS to email you when a step has gone wrong. Pretty normal stuff you might think I could do that in DTS in truth yes you could [...]