How to code SSIS package job thru CA Workload Automation ESP Edition?
search cancel

How to code SSIS package job thru CA Workload Automation ESP Edition?

book

Article ID: 42824

calendar_today

Updated On:

Products

ESP Workload Automation

Issue/Introduction

Question:

We are trying to schedule a job that would launch SSIS package job from a DSTX file rather than a definition in the SQL scheduler. How to code SSIS package job thru CA Workload Automation ESP Edition?

 

Environment

CA WA ESP Edition 11.4 Z/OS

 

Answer: 

 

There are two ways:

1. Use cmd.exe on CMDNAME, like:

CMDNAME C:\windows\system32\cmd.exe

ARGS /C "DSTX_file_and_parms"

2. Add the DSTX in the .cmd file.

 

Additional Information:

N/A

Environment

Release: ENCWLA00200-11.4-Workload Automation-Restart Option-EE
Component: