Scheduler Usage

Control-M with SSiS Package
Page 1 of 1

Author:  vivo95 [ 01 Sep 2011 4:54 ]
Post subject:  Control-M with SSiS Package


I'm new to the foum but is already somewhat familiar with the tool above Control-M system running on UNIX and SAP.

We have a new application on Windows 2008 running on the SAPBPC software and a database Microsoft SQL Server.

Data integration is done through SSIS packages.

It seems that we may, with Controlm, schedule these packages.

Do you know the mechanics?
Is there a documentation?

Should an agent "SSIS" on the Windows server to interface with the server ControlM as a SAP module to interface SAP with ControlM?


Author:  fileal2 [ 08 Sep 2011 7:01 ]
Post subject: 

You can use Control-M's CM for Databases to schedule SSIS packages.

You only have to install the CM on an agent that can connect to the SQL Server (or on the agent where the SQL server resides), ensure that the SQL Integration Service is running on the server(s) involved, and attribute the required Windows and SQL permissions to the configured user.

This is described on the Control-M for Databases Admin Guide.


Author:  asifden [ 29 Nov 2011 6:41 ]
Post subject: 

This was interesting.

Access Control System

Author:  masterrex [ 26 Jul 2013 12:27 ]
Post subject: 

I have used PowerShell remoting + dtexec.exe to invoke SSIS packages and return an exit code to Control-M jobs.

Page 1 of 1 All times are UTC+01:00
Powered by phpBB® Forum Software © phpBB Limited