...

...

...

...

...

...

I'm not sure that the links listed below will help you.

You may have to work from a Development Server that has both SQL Server 2005 & SQL Server 2008 to...

What documentation are you using to configure the Linked Server?

You may have to have SQL Server 2005 installed on a Server to do this but please check out the following links:

http://www.google.com/search?hl=en&as_q=SQL+Server+2008+Storing+or+modifying+packages+in+SQL+Server+requires+the+SSIS+runtime+and+database+to+be+the+same+version.+Storing+packages+in+earlier+versions+is+not+supported&as_epq=&as_oq=&as_eq=&num=10&lr=&as_filetype=&ft=i&as_sitesearch=&as_qdr=all&as_rights=&as_occt=any&cr=&as_nlo=&as_nhi=&safe=images

Installing (sql server 2005) SSIS packages on SQL Server...

I'm sorry but I'm in the middle of an install at the moment.

If you open the system SP's I referenced you will be able to identify the System Tables that...

Consider creating an error log file, etc...

Have you tried going into debug mode, stepping through the code,checking the variables, etc?

Not sure, but please start with these articles and research and determine if they applicable to your situation:

SQL Server SharePoint_Config database Transaction log backup plan failed

http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/3b1ac6d7-bd7a-46ee-8c7a-1d1b0e18bd56

SharePoint Database Growth Rates

http://vspug.com/llowevad/2007/06/25/sharepoint-database-growth-rates/

Massive SharePoint...

I do not know of the details but please check out the following articles:

Microsoft.SqlServer.Management.Smo.SimpleObjectKey' ... etc

http://iamberke.com/archive/2007/08/25/unable-to-cast-object-of-type-microsoft-sqlserver-management-smo-simpleobjectkey-etc.aspx

Can not create Job on SQL2005

http://social.msdn.microsoft.com/forums/en-US/sqlsmoanddmo/thread/79281b89-d305-44cc-9568-5dcff4620196/

Unable to create agent job after installing service pack 2.

https://connect.microsoft.com/SQLServer/feedback/details/271328/unable-to-create-agent-job-after-installing-service-pack-2

http://www.sqlservercentral.com/Forums/Topic384975-149-1.aspx#bm835905

http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-clustering/3393/Unable-to-Cast-Object

Converting it to an sp_executesql would be better than embedded Dynamic SQL for various reasons but it would be much better if you create a Stored Procedure and call the...