Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


PrimeCant
2013-02-21T16:21:24Z
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
Sponsor
Forum information
Support
2013-02-22T08:54:12Z
Please test this version - it should work there:

http://www.visualcron.co....aspx?g=posts&t=2948 
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
ddangoia
2013-08-03T14:28:05Z
I am having this same issue in Version 7.0.1 (build 15383)

Details:
64-bit SSIS Package
SQL Server version 2008

I am configuring a VisualCron variable to feed into the package called "batch_name" the variable name is the same in both the package and the VisualCron config screen.

In the "Execute SSIS Package" screen - I configure and setup the variable by pressing "Add" and then inputting the information, I then press "Ok" to save the configuration. When I click back into the task, all Variables are gone.

What are the next troubleshooting steps for this?

Thank you,
Danielle
Support
2013-08-05T21:25:42Z
Sorry, we have verified and fixed it in this version:

http://www.visualcron.co....aspx?g=posts&t=3295 
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top