Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSIS Package conversion from 2008 to 2005

Tags:

ssis

Has anybody found a way to save an SSIS 2008 package in the older 2005 version?

We are running both 2005 and 2008 instances and packages designed under VS 2008 need to be deployed to the 2005 server. Is there a way to do this?

Thanks in advance

like image 460
rmdussa Avatar asked Aug 04 '10 23:08

rmdussa


2 Answers

See Sql server Integration Services 2008-2005 compatibility

It has a reference to a useful ( even limited) tool

http://ssisdowngrade.codeplex.com

like image 132
Michael Freidgeim Avatar answered Oct 02 '22 16:10

Michael Freidgeim


Are you talking about saving your packages in a SQLServer store? I recommend you use deploy to file system. It is more flexible and there is no 2005/2008 restriction.

like image 23
Josef Richberg Avatar answered Oct 02 '22 16:10

Josef Richberg