SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

SQL Agent jobs that run SSIS packages

By TD Knight,

I was recently tasked with moving / ugrading SSIS packages from one server to another and I was instructed "to only move the packages that are executed by jobs".

This script joins three tables; sysjobs, sysjobsteps, and sysssispackages. It produces a list showing package name, job name, package folder name, and the job command. It is written for packages stored in msdb, but could easily be adapted for an SSIS package store. Additional columns could also be added.

Total article views: 418 | Views in the last 30 days: 52
 
Related Articles
FORUM

SSIS Package

SSIS Package

FORUM

DTS package

DTS package

FORUM

package instantiation

package instantiation

FORUM

Package configurations

Package configurations

FORUM

Creating Packages

Packages, Express

 
Contribute