Select Page

SSIS Email Task Delay Validation

Recently I was trying to send a file via Email in SSIS. For the connection to the file I was using a variable as the file name changes everyday. This post first appeared at http://thesqlgirl.com/2017/11/24/ssis-email-task-delay-validation/. The author is Jeanne...

MDS “Service Unavailable” Error

After restarting a server that has MDS on, I could no longer access MDS via the browser. This seemed very strange as I have restarted the server multiple times and it had never done this before. Turns out the Application Pool had stopped for MDS. So I started it up...

Limiting SSIS to a Single File Type

A while ago I was having some issues with SSIS and moving files. There was a hidden file called thumbs.db When SSIS was running the move file task it would fail because it can’t place duplicate files in the same location. The thumbs.db file was the problem. Even...

Indexing Temp Tables

While busy with query performance tuning and trying to see whether the query would run better using a CTE’s (Common Table Expression) or Temp tables and comparing times, I realised I forgot to think about adding indexes on my temp tables which could increase the...