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


klewis10367
2009-09-14T21:00:59Z
I am getting this error when trying to run a 2008 SQl SSIS package.

Unhandled exception in Task: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154.

It fails no matter what selection i choose, File or SQl Server.
Sponsor
Forum information
Support
2009-09-14T21:04:53Z
Which version are you using?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
Support
2009-09-14T21:09:57Z
I recommend testing version 5 as it should contain libraries for SQL server 2008.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
2009-09-14T21:10:53Z
Can i have a side by side installation of each version?
Support
2009-09-14T21:14:22Z
Yes and no, but version 5 installation will:

1. try to import settings from version 4 (and convert) so make a backup before.
2. disable VisualCron 4 service (you can only have one service running at a time at the same port number)
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
2009-09-14T21:54:55Z
Same problem in the newest version.
Support
2009-09-14T22:13:48Z
1. which service pack do you use?
2. do have have 64 or 32 bit OS?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
2009-09-14T22:14:58Z
SQL 2008 SP1, 32bit Windows 2003 SP2
Support
2009-09-14T22:20:14Z
Maybe a stupid question, but you are running VisualCron on the same machine as SQL server right?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
Support
2009-09-14T22:25:43Z
OK, thanks, we will do some testing and get back to you.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
2009-09-15T17:44:10Z
I also noticed, that when setting up a SQL ceonnection, there is no option for SQL 2008.
klewis10367
2009-10-01T15:28:27Z
Support
2009-10-08T08:46:29Z
We have not forgot this issue. It is just that it takes time as get the right environment for this. Meanwhile I recommend that you add you add the SSIS as a Job in the Server and execute the Job from VisualCron instead of using SSIS Task.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
2009-10-08T19:16:18Z
Thanks for the update. Actually i am running the SSIS packages through the command line using the dtexec. Works perfect.
Scroll to Top