Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

Using Tidal to Schedule SQL Server Jobs

Hello,

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?

I'm aware of the Tidal Enterprise Adapter for Microsoft SQL Server but I was wondering if anyone has been able to figure out an alternate solution.

Thanks

2 REPLIES
Silver

Hi Letron, In your batch file

Hi Letron,

 

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.

 

BR,

Derrick Au

New Member

is the Tidal Agent installed

is the Tidal Agent installed on that Windows server that hosts SQL Server 2012? if so you could call DTEXEC in CMD and pass it params

Tidal captures standard out and standard err so anything the package outputs should be in the output tab

Have you tried running DTEXEC direct w/out batch?

I would recommend powershell remoting

Invoke-Command -ComputerName <SQL2012Server> -scriptblock {DTExec.exe /File "<FullName>.dtsx"}

or

calling in a powershell script ... it gives you greater control over objects, output, exit codes (in case you use those in Tidal)

1019
Views
0
Helpful
2
Replies