Hello I am trying to migrate some SSIS packages from a 2008 instance to a 2008 R2 instance. I have exported the dtsx file from the 2008 instance. When I attempt to import the package into the R2 instance, Management Studio > SSIS > Import Package > File System > Rely on server storage and roles for access control (I am not encrypting the credentials). I receive an error message below when trying to import the package. I have run the package within Visual Studio on R2 instance and it runs perfectly. I have tried rebuilding the package on the R2's Visual Studio and importing but am still running into the same issue. Unfortunately I cannot do a side by side installation (so I have to migrate via the file system). If the error message displayed the actual problem I think I would be able to figure this one out. By the way I am naming the package LocalityFuzzy not . Does anyone have any clues? Thank you TITLE: Import Package ------------------------------ Object name "
" is not valid. Name must contain only alphanumeric characters or underscores "_". ({8BBB7189-4388-43F8-A081-9E01A9AB9C8E}) ------------------------------ ADDITIONAL INFORMATION: Object name "
" is not valid. Name must contain only alphanumeric characters or underscores "_". ({8BBB7189-4388-43F8-A081-9E01A9AB9C8E})

change your package name as error said, you should only have alphanumeric characters or underscores, could you set English name for package and try again( I think package name is Chinese)http://www.rad.pasfu.com

Rob Did you ever fix this - I am getting a similar problem Sethhttp://lqqsql.wordpress.com

Hi, The problem isn't with the names in the package it is with SSIS itself. I had recently installed SP4 on SQL 2005 on the same server where SQL 2008 r2 sat. I realised this was the only change I had made before this problem came along. To fix it I re-installed the latest hot fix for SQL 2008 r2 and rebooted the machine. Sethhttp://lqqsql.wordpress.com