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,835 reads

Blogs

Encryption in SQL Server #1 – Column Level Encryption

By

For one reason or another data security and encryption has been coming up quite...

Career: Talk To References

By

As we try to get through these strange times in the world, I am...

This Saturday: #DataWeekender, DataSaturday Southwest

By

Geeked to be speaking 2x on Saturday May 14, my second time speaking at...

Read the latest Blogs

Forums

SSIS Import only new values from a CSV without using a staging table

By datsun

Hello, How can I import a CSV file in SSIS (2016) at the same...

Query store index rebuilds

By Rasmus Remmer Bielidt

Recently we experienced a sudden surge in disk I/O every twenty minutes or so....

Group Managed Service Accounts for SQL Server 2017/2019

By @@caffeine_level

We use group managed service accounts for running the SQL Server 2017/2019 sqlserver.exe processes...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers