I finally found out the problem to the issue I had listed here below. I only had named instances on my new SQL 2008 server and no Default instance. ...
I have been using the SQL_Overview SSIS package specifically SQL_OVERVIEW_Part3 containing SQL_Overview_Package.dtsx in SQL 2005 quite some time with no issues. I copied the package...