• I was successful in using SQL Server 2008 "SQL Server Business Intelligence Development Studio" to open the SQL 2005 solution/package and migrating it to SQL Server 2008.

    I got some warnings about error counts. Looking at the package after the migrating, I fixed some mapping issues. I ignored the truncation issues.

    I ran this all on a local instance of SQL Server 2008 Standard edition SP1 10.0.2531.

    David Bird