My company uses the Tidal enterprise scheduler to execute SSIS packages on SQL Server 2012. We currently call a cmd batch file from Tidal on the Windows server that hosts SQL Server 2012. This batch file calls DTEXEC to execute the package on the server.
The problem we are having is that we do not get detailed status information from the SQL Server or Windows on the state of the package execution. Has anyone figured out a way to pass this information from the Windows/SQL Server to Tidal?
In your batch file, try calling dtexec package parameters.../REP levels > errors.txt to redirect your console messages, where levels can be EWI for (E)rrors, (W)arnings, (I)nformation. If blank, then defaults to (E)rrors, (W)arnings, and (P)rogress.
This document explains the logic to develop Tidal Enterprise
Orchestrator workflow to automate the process of creating vCenter
Resource Pool* vSphere Power CLI must be installed either on the TEO
server or vCenter* vMA can also be used to achieve the same...
IntorductionCisco Process Orcehstrator (CPO) ships with the webservices
adapter that can be used to make Web Service API call to REST or SOAP
based applications. Before a sample workflow to make SOAP API calls
using CPO, lets understand some of the fundam...