Post reply

SSIS Package Upgrade from Sql 2005 to 2008

  • July 21, 2010 at 9:42 pm

    #146311

    Hi,

    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

    http://msdn.microsoft.com/en-us/library/cc879336.aspx

    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.

    Regards,

    KRanp.

  • August 30, 2010 at 4:28 pm

    #1213980

    First we tried to upgrade the package using the package upgrade wizard from SSMS, but it failed with the error messages 'Cannot locate the config file at location....'

    When we opened the packages in BIDS we got warning messages for the config file location, using package configuration we specified config file path and upgraded the packages in the BIDS and deployed them back to MSDB and it worked out.

    Hope this helps,

    Thanks,

    -KRanp.

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

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