SQL 2008 SSIS Error - VisualCron

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

Welcome Guest! To enable all features please Login or Register.

klewis10367
Paid support Topic Starter

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

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

Support
Official support

2009-09-14T21:04:53Z

Which version are you using?

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

klewis10367
Paid support Topic Starter

2009-09-14T21:05:43Z

4.9.40

Support
Official 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
Paid support Topic Starter

2009-09-14T21:10:53Z

Can i have a side by side installation of each version?

Support
Official 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
Paid support Topic Starter

2009-09-14T21:54:55Z

Same problem in the newest version.

Support
Official 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
Paid support Topic Starter

2009-09-14T22:14:58Z

SQL 2008 SP1, 32bit Windows 2003 SP2

Support
Official support

2009-09-14T22:20:14Z

#10

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
Paid support Topic Starter

2009-09-14T22:20:59Z

#11

Yes

Support
Official support

2009-09-14T22:25:43Z

#12

OK, thanks, we will do some testing and get back to you.

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

klewis10367
Paid support Topic Starter

2009-09-15T17:44:10Z

#13

I also noticed, that when setting up a SQL ceonnection, there is no option for SQL 2008.

klewis10367
Paid support Topic Starter

2009-10-01T15:28:27Z

#14

Any update on this?

Support
Official support

2009-10-08T08:46:29Z

#15

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
Paid support Topic Starter

2009-10-08T19:16:18Z

#16

Thanks for the update. Actually i am running the SSIS packages through the command line using the dtexec. Works perfect.