Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to run SSIS package built on 2005 under 2008 Expand / Collapse
Author
Message
Posted Tuesday, April 23, 2013 3:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 5, 2013 7:52 AM
Points: 7, Visits: 19
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.
Post #1445325
Posted Tuesday, April 23, 2013 3:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:01 PM
Points: 13,720, Visits: 10,675
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1445332
Posted Tuesday, April 23, 2013 4:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 5, 2013 7:52 AM
Points: 7, Visits: 19
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?
Post #1445341
Posted Tuesday, April 23, 2013 4:38 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:01 PM
Points: 13,720, Visits: 10,675
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1445348
Posted Wednesday, April 24, 2013 3:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 5, 2013 7:52 AM
Points: 7, Visits: 19
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?
Post #1445827
Posted Wednesday, April 24, 2013 11:43 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:01 PM
Points: 13,720, Visits: 10,675
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1446146
Posted Friday, April 26, 2013 7:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 5, 2013 7:52 AM
Points: 7, Visits: 19
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?
Post #1446966
Posted Tuesday, April 30, 2013 7:01 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:01 PM
Points: 13,720, Visits: 10,675
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?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1448001
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse