I am trying to upgrade sql 2005 packages to sql 2008 after doing in-place upgrade of DE and SSIS. Can I know what packageformat column in msdb.dbo.sysssispackages refer to, as according to
the value should be 2 if the package is in sql 2005 and it should be 3 if it is upgraded. But I am seeing only 0 or 1.
Can I know any other method to figure out version of the ssis packages?
I am having issues upgrading SSIS Packages from 2005 to 2008, using SSIS package upgrade wizard.
Thanks for your help.
View Complete Post