Post reply

Migrate SSIS Packages

  • January 13, 2010 at 9:12 pm

    #218219

    Hey

    Can anybody tell me how to migrate SSIS packages from

    SQL Server 2005 to SQL Server 2008

    Thanks

  • January 14, 2010 at 8:51 am

    #1103666

    You can import the packages from BI studio if there are only a few of them.

    For a large number of packages, you can import the data from [msdb].[dbo].[sysssispackages] on 2005 server into the [msdb].[dbo].[sysssispackages] database on SQL 2008 server

    HTH...

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

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

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