SSIS upgrade issue for Konesans 2005 to 2008

Question

SSIS upgrade issue for Konesans 2005 to 2008

srinivasable

Mr or Mrs. 500

Points: 598
More actions
April 12, 2010 at 3:16 pm

#231669

Hi,
I have 200 to 240 SSIS packages for SQL 2005. Now we are in the process of upgrading from SQL 2005 to SQL 2008. We are using konesans (Checksum and Trash destination) in most of the packages. If we upgrade from SQL05 to SQL08 the konesans will automatically replace with konesans 2008 or we need to manually change the konesans 2005 to konesans 2008 in all the packages.
Thanks in Advance
Srinivas

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

I don't know this as fact but I think you'll probably have to do it manually. Also, some of the 2005 components seem to be compatible. But I would expect only the control-flow components to be compatible. The data-flow components have some objects that I don't see being compatible.

CEWII

COZYROC One Orange Chip Points: 28499 More actions · Answer 2

srinivasable (4/12/2010)
Hi,
I have 200 to 240 SSIS packages for SQL 2005. Now we are in the process of upgrading from SQL 2005 to SQL 2008. We are using konesans (Checksum and Trash destination) in most of the packages. If we upgrade from SQL05 to SQL08 the konesans will automatically replace with konesans 2008 or we need to manually change the konesans 2005 to konesans 2008 in all the packages.
Thanks in Advance
Srinivas

When you add existing package to SQL 2008 solution, it will automatically upgrade the components. Just make sure you have installed on the same machine:

- both SQL 2005 and 2008.

- both SQL 2005 and 2008 versions of the Konesans components.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

srinivasable Mr or Mrs. 500 Points: 598 More actions · Answer 3

Thanks for the Reply.

I am doing in windows Server 2008 box with SQL 2008. I upgraded all the packages but I am getting error for the Checksum and Trash destination components. I installed these components on windows server 2008 box

Thank you

Srini

COZYROC One Orange Chip Points: 28499 More actions · Answer 4

srinivasable (4/15/2010)
Thanks for the Reply.
I am doing in windows Server 2008 box with SQL 2008. I upgraded all the packages but I am getting error for the Checksum and Trash destination components. I installed these components on windows server 2008 box
Thank you
Srini

Do you have SQL 2005 and the version of the components for SQL 2005 installed , too? This will be required for the upgrade to work properly.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

srinivasable Mr or Mrs. 500 Points: 598 More actions · Answer 5

I tried to install 2005 konesans in windows 2008 but it's giving error.

Thank you

Srini

COZYROC One Orange Chip Points: 28499 More actions · Answer 6

srinivasable (4/15/2010)
I tried to install 2005 konesans in windows 2008 but it's giving error.
Thank you
Srini

What errors do you get? Did you have SQL 2005 installed in advance?

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/