We are trying to configure VisualCron to execute SSIS packages located in the SSISDB catalog.

The project deployment model of SSIS 2012 no longer stores packages in the MSDB or on the file system.
Instead a seperate SSIS catalog is created on the database server. The project deployment model also allows you to define different environments (DEV, TEST, PROD,..) to assign correct values for the parameters used in your packages according to the environment against they are executed.

I already succeeded in executing a package using VisualCron. Unfortunately there is no option in VisualCron to specify the environment from which the parameters in the packages should receive their value.

Below a screenshot of this option within the native SQL Server job agent.



Please advise how I can select the environment using VisualCron.

Cheers,
Chris

Thank you for your message. Currently I do not see that this is supported in the API that we use. We have posted some questions online but it does not look so good right now.

---

So it is the API of Microsoft that is missing this functionality?

Thanks,
Chris

Yes, we cannot see this functionality in the API.

---

Could this help?

http://technet.microsoft...integrationservices.aspx 

Could you give me an update? We need to take a decission on our project whether or not we continue to use Visual Cron...

Thanks,
Chris

Sorry for the late reply. Thanks for the link. We have investigated it and we do not use that namespace, we are using Microsoft.SqlServer.Dts.Runtime which does not support it. At first glance I cannot say if your link can solve all current features.

If this feature is really important do you we could custom build it for you. But to do that we need to know if you are a current customer, number of licenses you are interested in etc (before making that time investment). Please email sales@visualcron.com

---