April 23, 2013 at 3:20 am
I hope Im on the right forum for this, if not please point this out to me.
I have migrated a website from one server to another.
On this new webserver SQL server express 2008 is installed.
The website on the frontend works fine.
However, the backend of the website contains some functionality with which one can upload a .csv-file to import some data into the database by running an SSIS package.
Since the migration of the website to the new server this results in the following exception:
"Retrieving the COM class factory for component with CLSID {BA785E28-3D7B-47AE-A4F9-4784F61B598A} failed due to the following error: 80040154"
The cause of this problem, according to numerous sources, is the fact that this package was built under SQL Server 2005 and that its missing some Class with the above classGuid.
Apparantly these were all renamed in SQL Server 2008.
I have installed SQL Server 2005 on the said webserver, but the error persists. It seems that the .dll needed still isnt installed with SQL Server 2005.
Also i have created a database running on SQL Server 2005 and created a second version of the website which uses that database. But still this does not resolve the problem.
Can somebody please help me?
Thanks in advance.
April 23, 2013 at 3:45 am
SSIS 2005 packages need to be upgraded before you can run them with a 2008 instance. However, SSIS doesn't work with Express versions, so your 2008 express version is useless for SSIS.
If you want to install the 2005 components to run the 2005 package, make sure you install the Integrations Services service from the SQL Server setup.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 23, 2013 at 4:12 am
Hi Koen,
Thanks for your reply.
I have the source of the project repsonsible for this functionality and im downloading visual studio 2008 right now to be able to open it.
How can i upgrade those packages to 2008, how does that work?
April 23, 2013 at 4:38 am
haastnooit (4/23/2013)
Hi Koen,Thanks for your reply.
I have the source of the project repsonsible for this functionality and im downloading visual studio 2008 right now to be able to open it.
How can i upgrade those packages to 2008, how does that work?
If you open it in BIDS 2008 it will upgrade automatically.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 24, 2013 at 3:53 am
I was finally able to install BIDS and open the project, but it does not upgrade automatically.
Is there a way I can force it to do that?
How can I be sure that the project was built under 2005 and not under 2008? Maybe that's reason it doesn't upgrade automatically.
I can however build the project, but when I try to run it I receive the same error I mentioned in my original post.
When I right click the Packages folder and select the option 'Migrate 2000 DTS Packages' I receive an error that SSIS is required.
But never during the installation SQL 2008 (or R2) express can I select Integration Services.
Is this not a part of Express editions?
April 24, 2013 at 11:43 am
haastnooit (4/24/2013)
I was finally able to install BIDS and open the project, but it does not upgrade automatically.Is there a way I can force it to do that?
How can I be sure that the project was built under 2005 and not under 2008? Maybe that's reason it doesn't upgrade automatically.
I can however build the project, but when I try to run it I receive the same error I mentioned in my original post.
When I right click the Packages folder and select the option 'Migrate 2000 DTS Packages' I receive an error that SSIS is required.
But never during the installation SQL 2008 (or R2) express can I select Integration Services.
Is this not a part of Express editions?
I already mentioned SSIS is not covered in Express.
You'll need at least standard edition.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 26, 2013 at 7:12 am
Yes sorry about that.
I got the right software now.
The last couple of days i have been trying to install said features, but it kept whining about the fact that i needed Visual Studio 2008 SP1, which i had installed.
Today i decided to delete all versions of Visual Studio and all related files and packes that were installed.
SQL Server 2008 and the selected features are finally actually installing.
I just can't believe how this process can be so cumbersome.
Im hoping the procedure you described will now work.
Thanks a lot for your help and time.
Well a quick update. It didnt work.
I can now upgrade the packages by right clicking the SSIS packages folder which will start the process.
1. Upgrading package Package.dtsx - Succes
Still i get the same error, how is this possible?
April 30, 2013 at 7:01 am
So you installed SQL Server 2008 (at least standard edition) and you upgraded the package to SSIS 2008?
Any errors/warnings during the upgrade?
Do you use a script task/component in the package?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply