Greetings,

I'm testing VisualCron on a trial basis, and am running into trouble trying to create a task that will run an SSIS package. Inside this package, we execute a Execute SQL Task to truncate a table, and then load the table. However, when I setup the task in VC, and run it, I get the following error:

Number of errors: 1
Error (0):The Execute method on the task returned error code 0x80131621 (Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.). The Execute method must succeed, and indicate the result using an "out" parameter.

If I remove the Execute SQL Task, then the package succeeds, so I have a strong feeling the problem is with that one SSIS task. Any thoughts?

Thanks!
Nick

I think this is resolved in 7.5.1 or 7.5.2. Could you test 7.5.1 first to see if it is resolved. We plan to release 7.5.2 next week and you can download the beta here:

http://www.visualcron.co....aspx?g=posts&t=4676 

---

Henrik,

The problem currently occurs in 7.5.1.

Thanks,
Nick

Then it is fixed in 7.5.2. But let me know which version of MSSQL server you use (setting in VisualCron) and 32 or 64 bit setting in VisualCron so I can guide you to manually update a file.

---

The visual cron task is using: SQL Version: 2014, 64bit setting.

Thanks!

I am attaching a file. Please replace this file with the one in: C:\Program Files (x86)\VisualCron\MSSQL2014

Please let me know if it works better.

---

Henrik,

The zip file appears to only contain a config file, and there wasn't one to replace in the directory - should there have been a .exe in there as well?

Thanks,
Nick

Henrik,

The zip file appears to only contain a config file, and there wasn't one to replace in the directory - should there have been a .exe in there as well?

Thanks,
Nick

There are two exe files in that directory. And one config file for each exe should exist.

---

That did the trick! Thanks for your help!

Thanks for the feedback!

---