Integration Services (SSIS)

Run SQL Server Agent Job from SSIS

  • Article

While we can schedule SQL Server Agent jobs and SSRS report subscriptions, the actual time that we want to run them is dependent on when certain processing in our SSIS packages is completed. We also have certain business rules surrounding launching these jobs that we need to enforce which the built-in scheduling capabilities cannot accommodate. For example, we execute a SQL Server Reporting Services (SSRS) report subscription every Monday at 8:00AM but we want to skip it if the current week coincides with our month end processing which will also execute a report subscription for the same report. Can you provide a solution that we can use to accomplish this?

2020-05-19

SSISDB Catalog Defaults Best Practices

  • Article

Introduction The SSISDB database (a.k.a. the SSISDB catalog) was introduced back in SQL Server 2012 to de-clutter the MSDB database and provide an in-house logging and reporting infrastructure. In a nutshell, SSISDB is an SSIS framework making SQL Server Integration Services more robust and enterprise-friendly by providing the following features: Database backup Database encryption Support […]

5 (1)

2019-12-26

4,617 reads

Blogs

Updated Pluralsight Course – Kubernetes Installation and Configuration Fundamentals

By

My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want...

Power BI and a Star Schema

By

I sometimes get asked from customers if they should use a star schema or...

A New Git Default Branch

By

I learned a new trick from Andrew Pruski. In a blog on avoiding PowerPoint,...

Read the latest Blogs

Forums

User unable to see Logins after recreation of permissions in new instance

By johnylemony

Hello All I was tasked with setting up a new instance on the same...

Monitor SQL Server Error Logs with PowerShell

By WillemG

Comments posted to this topic are about the item Monitor SQL Server Error Logs...

Adding N/A

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding N/A

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Adding N/A

See possible answers