Hi,
We are using VisualCron 6.1.8 to run some SSIS package. And we are facing some very strange issues when setting up the variables for the SSIS package. Every time we setup the variables for the SSIS package, all the variables will just disappear after we click OK to save them. It did not happen in the trial version we used, which was why we bought the licence.
Then we tried to call the DTEXEC command directly by using "Execute". This time, VisuaCron could not process one of the arguments I passed. I tested all the arguments directly in the DTEXEC command line and all the arguemnts are valid. Here is the argument that has error in VisualCron:
/SET "\Package.Variables[User::Connection].Properties[Value]";"\"Data Source=prod-pb;Initial Catalog=XX_DW;User Id=user;Password=pwd;\""
So now we basicly cannot call any SSIS package with variables needed to be passed in.Neither calling the DTEXEC or using "Execute SSIS package" will not work in VisualCron.
Can someone please look into this issue?
Thanks,
Cantor