SSIS Package related

1
Is there a way to trigger SSIS packages via Mendix ?  Has someone tried executing SSIS packages using Mendix or any Mendix Widget ?
asked
1 answers
1

Hi Samridh,

 

I think there are probably several ways that this could be accomplished. But doing a quick google gave me a few options. Mendix can be extended by custom java actions and by the look of this forum post it is possible to call SSIS packages from Java actions either remotely or on local machine. 

 

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/39bcb5e5-fa54-4631-86fd-3f6f5802dd4d/call-package-from-java-and-pass-db-connection-data-to-it?forum=sqlintegrationservices

 

The other option is that you could expose a service in either REST or SOAP to allow Mendix to call an SSIS service which will run the package.

 

I hope this helps you. I am not an expert on SSIS, but have some experience integrating it into Mendix. Last time i did it was the other way, so importing data into SSIS using a WebService exposed on the Mendix side.

 

Regards

Simon 

 

 

answered