Archive for

Customizing SSRS Subscription Schedules

How frustrating is it when setting up an SSRS report subscription to be stuck with the standard  run times Daily, Hourly etc. With no options for adjusting or customizing the schedule to lets say just running during core business hours or exclude weekends etc. I have always found this to be a major shortcoming of … Continue reading

Understanding the SSIS Package Protection Level

One property of all SSIS packages that you must understand is the ProtectionLevel. This property tells SSIS how to handle sensitive information stored within your packages. Most commonly this is a password stored in a connection string. Why is this information important? If you don’t set the ProtectionLevel correctly, the package may become unusable. Other … Continue reading