SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Unable to run SSIS package built on 2005 under 2008


Unable to run SSIS package built on 2005 under 2008

Author
Message
haastnooit
haastnooit
Valued Member
Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)

Group: General Forum Members
Points: 65 Visits: 20
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.
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: General Forum Members
Points: 63902 Visits: 13298
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
haastnooit
haastnooit
Valued Member
Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)

Group: General Forum Members
Points: 65 Visits: 20
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?
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: General Forum Members
Points: 63902 Visits: 13298
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
haastnooit
haastnooit
Valued Member
Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)

Group: General Forum Members
Points: 65 Visits: 20
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?
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: General Forum Members
Points: 63902 Visits: 13298
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
haastnooit
haastnooit
Valued Member
Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)

Group: General Forum Members
Points: 65 Visits: 20
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?
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: General Forum Members
Points: 63902 Visits: 13298
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search